Re: ALTER TABLE RENAME fix

From: Brent Verner <brent(at)rcfile(dot)org>
To:
Cc: pgsql-patches(at)postgresql(dot)org
Subject: Re: ALTER TABLE RENAME fix
Date: 2001-11-11 02:10:05
Message-ID: 20011110211005.A98616@rcfile.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-patches

On 10 Nov 2001 at 20:26 (-0500), Brent Verner wrote:

| <light bulb over head>

<sound of light bulb busting>

| no doubt, very badly/misleadingly written. There is no reason for
| me to reconstruct the new tgargs for each tuple at all. I just need
| to do the check against PK_RELNAME and FK_RELNAME for the first tuple
| that needs updating, since the tgargs is the /same/ for all calls to
| this trigger... but we have to check both PK_RELNAME and FK_RELNAME,
| since we don't know which side of the constraint this relname is on.
| The following pseudo-code describes all I need to do.

disregard this idea. It will not do the right thing with multiple
constraints.

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

In response to

Browse pgsql-patches by date

  From Date Subject
Next Message Brent Verner 2001-11-11 02:13:11 Re: ALTER TABLE RENAME fix
Previous Message Tom Lane 2001-11-11 01:41:58 Re: ALTER TABLE RENAME fix