[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[gnue] r9781 - trunk/gnue-common/src/datasources/drivers/sql/interbase
From: |
johannes |
Subject: |
[gnue] r9781 - trunk/gnue-common/src/datasources/drivers/sql/interbase |
Date: |
Thu, 20 Sep 2007 09:50:32 -0500 (CDT) |
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"
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [gnue] r9781 - trunk/gnue-common/src/datasources/drivers/sql/interbase,
johannes <=