The following bug has been logged online:
Bug reference: 4103
Logged by: Yu Jye Foo
Email address: yu.jyefoo@[EMAIL PROTECTED]
version: 8.3.0
Operating system: Windows XP x64
Description: DELETE Syntax Error
Details:
2008-04-11 09:01:02 PDT ERROR: syntax error at or near "LIMIT" at
character
97
2008-04-11 09:01:02 PDT STATEMENT: DELETE FROM BASELINES WHERE file_id IN
(SELECT file_id FROM files WHERE config_id = 1155042061) LIMIT 4001;
To remove the possibility that the database was invalid,
SELECT * FROM BASELINES WHERE file_id IN (SELECT file_id FROM files WHERE
config_id = 1155042061) LIMIT 4001;
has no issues running.
Removing the "LIMIT 4001" yields the same issue. I am communicating with
the
database through the psqlODBC driver.
--
Sent via pgsql-bugs mailing list (pgsql-bugs@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
