Hi, > After that I ran my code example, using an existing postgresql DB (created > with the first schema), but when the "upgrade" function was invoked this > exception was raised: > > Query:ALTER TABLE Point_backup ADD COLUMN h_; failed: ERROR: syntax error at > or near ";" > LINE 1: ALTER TABLE Point_backup ADD COLUMN h_; > > Probably postgresql needs the field type of new column, instead using sqlite3 > db everything works fine. Can anyone tell me how can I solve this problem?
Yes, definitive, but sqlite not because it uses dynamic column types. This is a bug, i thought it was fixed some months ago. I have to look again on it, it must be somewhere in database.cpp. Kind regards, gulliver ------------------------------------------------------------------------------ Throughout its 18-year history, RSA Conference consistently attracts the world's best and brightest in the field, creating opportunities for Conference attendees to learn about information security's most important issues through interactions with peers, luminaries and emerging and established companies. http://p.sf.net/sfu/rsaconf-dev2dev _______________________________________________ Litesql-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/litesql-users
