BUG #4103: DELETE Syntax Error
От | Yu Jye Foo |
---|---|
Тема | BUG #4103: DELETE Syntax Error |
Дата | |
Msg-id | 200804111657.m3BGvIA6014132@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #4103: DELETE Syntax Error
|
Список | pgsql-bugs |
The following bug has been logged online: Bug reference: 4103 Logged by: Yu Jye Foo Email address: yu.jyefoo@autodesk.com PostgreSQL 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.
В списке pgsql-bugs по дате отправления: