Re: ALTER TABLE RENAME fix - Mailing list pgsql-patches

From Peter Eisentraut
Subject Re: ALTER TABLE RENAME fix
Date
Msg-id Pine.LNX.4.30.0111121804420.640-100000@peter.localdomain
Whole thread Raw
In response to ALTER TABLE RENAME fix  (Brent Verner <brent@rcfile.org>)
Responses Re: ALTER TABLE RENAME fix  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: ALTER TABLE RENAME fix  (Brent Verner <brent@rcfile.org>)
List pgsql-patches
Brent Verner writes:

> These patches fix the problem where an
>
>   ALTER TABLE <table> RENAME <oldcolumn> TO <newcolumn>
>
> did not update the RI_ triggers if the oldcolumn was referenced in
> a RI constraint.

Instead of trying to fix this, how about making the RI triggers not use
the column names in the first place.  (Instead they should use the oid of
the table and the attnums.)

--
Peter Eisentraut   peter_e@gmx.net


pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: stupid patch of pg_dumplo
Next
From: Tom Lane
Date:
Subject: Re: ALTER TABLE RENAME fix