ALTER TABLE fixes (take two)

From: Brent Verner <brent(at)rcfile(dot)org>
To: pgsql-patches(at)postgresql(dot)org
Subject: ALTER TABLE fixes (take two)
Date: 2001-11-11 09:18:44
Message-ID: 20011111041844.B99927@rcfile.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

Hi all,

Following Tom's guidance (as best I could) I have a much better
patch for fixing the ALTER TABLE woes. It properly handles renaming
tables and columns under every circumstance I've tested -- including
self-referential FK/PK.

First patch is to move defines around so I can get to them from the
rename.c file.

Second patch adds the update_ri_trigger_args() function which is called
from renameatt() and renamerel() to keep the pg_trigger.tgargs in sync
with the renamed att/rel.

cheers.
brent

--
"Develop your talent, man, and leave the world something. Records are
really gifts from people. To think that an artist would love you enough
to share his music with anyone is a beautiful thing." -- Duane Allman

Attachment Content-Type Size
pgsql-1.diff text/plain 3.0 KB
pgsql-5.diff text/plain 10.1 KB

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2001-11-11 15:40:38 Re: Patch for Makefile race against current cvs
Previous Message Brent Verner 2001-11-11 09:06:14 Re: ALTER TABLE RENAME fix