BUG #4103: DELETE Syntax Error

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.

Responses

Browse pgsql-bugs by date

  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