Search Postgresql Archives

Re: Renaming a constraint

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Csaba Nagy <nagy@xxxxxxxxxxxxxx> writes:
> On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote:
>> Csaba Nagy <nagy@xxxxxxxxxxxxxx> 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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux