Thread: Renaming a constraint
I found an old post regarding the subject, where modifying the pg_constraint entry was recommended: http://archives.postgresql.org/pgsql-admin/2003-04/msg00339.php Is this still safe to do ? The pertinent docs don't say anything pro or contra: http://www.postgresql.org/docs/8.2/static/catalog-pg-constraint.html I need to rename a few constraints to keep our schema logically consistent. It would be of course nice to have an ALTER TABLE option to do it, but if updating pg_constraint is safe it would do it for now. Thanks, Csaba.
Csaba Nagy <nagy@ecircle-ag.com> writes: > I found an old post regarding the subject, where modifying the > pg_constraint entry was recommended: > http://archives.postgresql.org/pgsql-admin/2003-04/msg00339.php > Is this still safe to do ? What kind of constraint? regards, tom lane
On Tue, 2008-02-05 at 12:11 -0500, Tom Lane wrote: > Csaba Nagy <nagy@ecircle-ag.com> writes: > > I found an old post regarding the subject, where modifying the > > pg_constraint entry was recommended: > > > http://archives.postgresql.org/pgsql-admin/2003-04/msg00339.php > > > 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). Thanks, Csaba.
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
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.