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


Tue, 17 Oct 2000 11:02:59 -0400 (EDT)
Alex Pilosov <alex@pilosoft.com>
bug: alter table/FK

Under current sources, it no longer crashes, it just elogs now 
after Tom's changes.  When I get more time I'd like to put in a
more complete solution (possibly moving to oids rather than names
in the argument list in the process).  There are alot of other related
problems (rename column, check constraint dumping after column/table
renames, dropping objects that refer to other objects that have
been removed, drop ... restrict vs cascade)

On Tue, 17 Oct 2000, Alex Pilosov wrote:

> 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


Tue, 17 Oct 2000 08:58:14 -0700 (PDT)
Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: bug: alter table/FK