Jerome O\'Neil (joneil(at)combimatrix(dot)com) reports a bug with a severity of 2
The lower the number the more severe it is.
SELECT updatability clause defective.
The syntax for select updatability clause is non-standard. Postgres describes select updatability as
[FOR UDATE [OF tablename]]
While SQL-92 BNF describes it as
[FOR UPDATE [OF <column name list>]]
This breaks portability for third party tools (like BEA Weblogic JMS hint hint...)
Also, your bug tool doesn't like people with apostrophies in their name.
CREATE TABLE foo (column1 int4, column2 int4);
INSERT INTO foo VALUES (1,2);
-- Broken Postgres syntax
SELECT column1 FROM foo where column1 = 1 FOR UPDATE OF foo;
-- Nice and friendly SQL-92 syntax
SELECT column1 FROM foo where column1 = 1 FOR UPDATE OF column1;
No file was uploaded with this report
pgsql-bugs by date
|Next:||From: pgsql-bugs||Date: 2001-05-09 17:09:08|
|Subject: Better dump of foreign key data|
|Previous:||From: Tom Lane||Date: 2001-05-09 15:09:02|
|Subject: Re: Another plpgsql crash |