Q: Rename constraint - Mailing list pgsql-general

From Tilo Schwarz
Subject Q: Rename constraint
Date
Msg-id 200301281847.57589.mail@tilo-schwarz.de
Whole thread Raw
Responses Re: Q: Rename constraint
List pgsql-general
Hi,

I want to rename several constraints. But I didn't find a way to rename a
constraint (eg. a foreign key constraint) except of dropping and recreating
it (with alter table) - am I right?

Now my question is, if I can directly change the value of
"pg_constraint.conname", or am I calling for trouble that way?

Thanks and regards,

    Tilo


pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: Compiling with -O3 optimization
Next
From: Tom Lane
Date:
Subject: Re: serialization errors