tfischer 2005/03/26 23:52:13
Modified: src/generator/src/templates/sql/base/postgresql drop.vm
table.vm
Added: src/generator/src/templates/sql/base/postgresql sequence.vm
Log:
Generate sequences for postgresql explicitly
Revision Changes Path
1.4 +4 -1
db-torque/src/generator/src/templates/sql/base/postgresql/drop.vm
Index: drop.vm
===================================================================
RCS file:
/home/cvs/db-torque/src/generator/src/templates/sql/base/postgresql/drop.vm,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- drop.vm 20 Aug 2004 11:48:46 -0000 1.3
+++ drop.vm 27 Mar 2005 07:52:12 -0000 1.4
@@ -1 +1,4 @@
-DROP TABLE $table.Name CASCADE;
+DROP TABLE $table.Name;
+#if ($table.IdMethod == "native")
+DROP SEQUENCE $table.SequenceName;
+#end
1.3 +3 -0
db-torque/src/generator/src/templates/sql/base/postgresql/table.vm
Index: table.vm
===================================================================
RCS file:
/home/cvs/db-torque/src/generator/src/templates/sql/base/postgresql/table.vm,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- table.vm 20 Aug 2004 11:48:46 -0000 1.2
+++ table.vm 27 Mar 2005 07:52:12 -0000 1.3
@@ -4,6 +4,9 @@
-----------------------------------------------------------------------------
$generator.parse("$basepath/drop.vm", "", "table", $tbl)
+#set ( $sequence = $generator.parse("$basepath/sequence.vm", "", "table",
$tbl) )
+#if ($sequence.length()>0)$sequence#end
+
CREATE TABLE $table.Name
(
#set ( $cols = $generator.parse("$basepath/columns.vm", "", "table",$tbl) )
1.3 +1 -1
db-torque/src/generator/src/templates/sql/base/postgresql/sequence.vm
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
