From: | "Yu Jye Foo" <yu(dot)jyefoo(at)autodesk(dot)com> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #4103: DELETE Syntax Error |
Date: | 2008-04-11 16:57:18 |
Message-ID: | 200804111657.m3BGvIA6014132@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4103
Logged by: Yu Jye Foo
Email address: yu(dot)jyefoo(at)autodesk(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-11 17:47:26 | Re: BUG #4103: DELETE Syntax Error |
Previous Message | jalvarez | 2008-04-11 15:31:19 | error php - postgresql |