sbelt wrote: > I am using Torque outside of Turbine. I am using a CVS-version from Dec. > 26th on Linux. I am also using Postgresql as my database. I created my own > schema.xml which creates 6 tables and several Foreign Keys among them. In > getting this running, I found 2 issues: > > 1) The .sql created by ant adds commas to the end of the last column which > causes the .sql to fail. For example, torque generated: > > drop table table1; > CREATE TABLE table1 > ( > x1 serial, > x2 varchar (256), > PRIMARY KEY(x1), <-- this is the troublesome comma > ); > > Postgres does not like the comma after the PRIMARY KEY definition when I run > this .sql using psql. I got around this by editing the .sql to remove these > extra commas. Now the .sql works.
i'm generating sql with torque multiple times a day for different rdbms .. and it works fine for me ... which version ov velocity are you using?? try to update your velocity.jar > > 2) The comments at the end of the generated .sql incorrectly label the > foreign key defintions. The keys generated for table-3 are labeled as "-- > table-2". The SQL commands are actually correct (so you do not need to > modify the .sql if you don't want), it is just the commented labels which > are incorrect. i'll take a look at this martin -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
