Re: Renaming a constraint - Mailing list pgsql-general

From Tom Lane
Subject Re: Renaming a constraint
Date
Msg-id 9987.1202313835@sss.pgh.pa.us
Whole thread Raw
In response to Re: Renaming a constraint  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: Renaming a constraint
List pgsql-general
Csaba Nagy <nagy@ecircle-ag.com> writes:
> On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote:
>> Csaba Nagy <nagy@ecircle-ag.com> writes:
>>> Is this still safe to do ?
>>
>> What kind of constraint?

> The only ones left are foreign key constraints. I had a few not nulls
> too, but those are not actually there anyway (see my other post).

IIRC, the name of an FK constraint also appears in the arguments for its
triggers.  If you didn't update those too, the behavior might be a bit
inconsistent, depending on which PG version you're using.  In particular
I'm not sure which name pg_dump will believe.

            regards, tom lane

pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: postgresql book - practical or something newer?
Next
From: Csaba Nagy
Date:
Subject: Re: Renaming a constraint