bug: alter table/FK - Mailing list pgsql-hackers

From Alex Pilosov
Subject bug: alter table/FK
Date
Msg-id Pine.BSO.4.10.10010171059530.22422-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: bug: alter table/FK
List pgsql-hackers
I don't know if this has been fixed or not, but alter table will not
adjust RI/FK triggers on the table. 

I.E:

create table foo (a int4 primary key)
create table bar (b int4 references foo)
alter table foo rename to foo2

now, updates to foo will either crash or hang postgres.


What needs to be done: on alter table, update tgargs in pg_trigger table

-alex



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql is 75 times faster with my new index scan
Next
From: Peter Eisentraut
Date:
Subject: Re: "initdb -t" destroys all databases