bug: alter table/FK

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: bug: alter table/FK
Date: 2000-10-17 15:02:59
Message-ID: Pine.BSO.4.10.10010171059530.22422-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2000-10-17 15:05:14 Re: length coerce for bpchar is broken since 7.0
Previous Message Tom Lane 2000-10-17 14:32:49 Re: PL/Perl compilation error