[gnue] r9781 - trunk/gnue-common/src/datasources/drivers/sql/interbase

[johannes]

Author: johannes
Date: 2007-09-20 09:50:31 -0500 (Thu, 20 Sep 2007)
New Revision: 9781

Modified:
   trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py
Log:
Use unique Trigger names.  This avoids conflicts if two tables are using 
a serial with the same name


Modified: trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py
===================================================================
--- trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py 
2007-09-20 13:08:40 UTC (rev 9780)
+++ trunk/gnue-common/src/datasources/drivers/sql/interbase/Behavior.py 
2007-09-20 14:50:31 UTC (rev 9781)
@@ -430,9 +430,9 @@
 
       code [0].append (u"CREATE GENERATOR %s" % seq)
       code [2].append ( \
-        u"CREATE TRIGGER trg_%s FOR %s ACTIVE BEFORE INSERT POSITION 0 AS " \
+        u"CREATE TRIGGER trg_%s_%s FOR %s ACTIVE BEFORE INSERT POSITION 0 AS " 
\
          "BEGIN IF (NEW.%s IS NULL) THEN NEW.%s = GEN_ID (%s,1); END" \
-        % (field.name, table.name, field.name, field.name, seq))
+        % (field.name, table.name, table.name, field.name, field.name, seq))
 
     elif field.defaultwith == 'timestamp':
       field.default = "NOW"