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.
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 hope this helps someone if they are having similar difficulties.
Steve B.
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
