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;
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 |