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 |
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 |