Re: ALTER TABLE RENAME fix

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Brent Verner <brent(at)rcfile(dot)org>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: ALTER TABLE RENAME fix
Date: 2001-11-12 17:28:28
Message-ID: Pine.LNX.4.30.0111121804420.640-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net

In response to

Responses

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2001-11-12 17:38:59 Re: stupid patch of pg_dumplo
Previous Message Bruce Momjian 2001-11-12 16:44:21 Re: stupid patch of pg_dumplo