Re: Renaming a constraint - Mailing list pgsql-general

From Csaba Nagy
Subject Re: Renaming a constraint
Date
Msg-id 1202314567.29220.73.camel@PCD12478
Whole thread Raw
In response to Re: Renaming a constraint  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Wed, 2008-02-06 at 11:03 -0500, Tom Lane wrote:
> 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.

OK, I think I'll just give up on renaming them.

How hard would be to implement renaming constraints as an alter table
option ? It sounds to me like it should be a task requiring mostly
legwork than programming skills, would it be good task for a beginner in
C like me ? If it is at all regarded as a needed feature...

Thanks,
Csaba.



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Renaming a constraint
Next
From: Tom Hart
Date:
Subject: Re: postgresql book - practical or something newer?