Following up to my earlier mail I have identified that this process of generating a weird additional comma occurs on both Solaris and Linux, but not on Windows.
Basically the xxx-schema.sql file seems to being created differently on these different OS's. Can anybody think of a some OS difference that would affect this SQL generation process? Thanks in advance CHEERS> SAM Sam Joseph wrote: > Hi all, > > So I have created this package that includes torque and various stuff. > I've run it on my windows box against mysql and postgre no problem. > However when I try the same thing on a linux box (against mysql) the > main table creation SQL seems to come out all screwy:. e,g, > > [torque-insert-sql] Failed to execute: CREATE TABLE KEYWORD ( > KEYWORD_ID INTEGER NOT NULL, KEYWORD VARCHAR (255) NOT NULL, PRIMARY > KEY(KEYWORD_ID), INDEX KEYWORD_IDX_1 (KEYWORD_ID), INDEX KEYWORD_IDX_2 > (KEYWORD), ) > > [notice the trailing comma in the above] > > whereas on windows I get the correct form > > CREATE TABLE KEYWORD ( KEYWORD_ID INTEGER NOT NULL, KEYWORD VARCHAR > (255) NOT NULL, PRIMARY KEY(KEYWORD_ID), INDEX KEYWORD_IDX_1 > (KEYWORD_ID), INDEX KEYWORD_IDX_2 (KEYWORD)) > > Has anyone had any experience with something like this? > > The package I've created is available from > > ftp://www.neurogrid.net/pub/installs/torque-ng.tar.gz > > if you want to see any of my settings .... > > thanks in advance. > > CHEERS> SAM > > > -- > To unsubscribe, e-mail: > <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: > <mailto:[EMAIL PROTECTED]> > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
