Foreign key plan caching (too long!)

From: Rod Taylor <rbt(at)rbt(dot)ca>
To: PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org>
Subject: Foreign key plan caching (too long!)
Date: 2003-10-09 16:43:01
Message-ID: 1065717781.45504.17.camel@jester
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Below is a short script which causes an error in the foreign key plan
caching. It appears to cause the error with or without the transaction,
but closing the connection between steps causes it to go away.

Can the cache be cleared after each statement?

Error reported:
psql:/home/rbt/bugtest:18: ERROR: could not open relation with
OID 26353

Script:
begin;

create table a (col integer primary key);

create table b (col integer primary key references a on update
cascade on delete cascade);


insert into a values (1);
insert into b values (1);

insert into a values (2);
insert into b values (2);

delete from a where col = 1;

alter table b drop constraint b_pkey;

delete from a where col = 2;

commit;

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-10-09 16:46:21 Re: [COMMITTERS] pgsql-server/src/template bsdi freebsd
Previous Message Andrew Sullivan 2003-10-09 16:07:18 Re: 2-phase commit