[HACKERS] Bug in 8.2B1 plpgsql ...

[James Robinson]

Seems that plpgsql in 8.2B1 thinks that selects of the form ' .... and foo not in (select ... )' should be function calls, not subselects. These worked fine in 8.1.

Here's a smallish script which reproduces the problem on 8.2RC1 / OSX:




social=# \i 8.2.bug.sql
BEGIN

CREATE TABLE
CREATE TABLE
CREATE SEQUENCE
CREATE TABLE
CREATE FUNCTION
CREATE TRIGGER
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
psql:8.2.bug.sql:52: ERROR:  cache lookup failed for function 0

PL/pgSQL function "track_t1_changes" line 2 at if
ROLLBACK

If you comment out the 'and NEW.id not in (select t1_id from skip_t1_ids) ' clause in the trigger, then the script completes. psql:8.2.bug.sql:15: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "t1_pkey" for table "t1" CONTEXT: SQL statement "SELECT $1 <> $2 and $3 not in (select t1_id from skip_t1_ids)"

8.2.bug.sql
Description: Binary data

----
James Robinson
Socialserve.com


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faq