Q: Rename constraint

From: Tilo Schwarz <mail(at)tilo-schwarz(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Q: Rename constraint
Date: 2003-01-28 17:47:57
Message-ID: 200301281847.57589.mail@tilo-schwarz.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Francisco Reyes 2003-01-28 17:56:52 Compiling with -O3 optimization
Previous Message Tom Lane 2003-01-28 17:47:20 Re: serialization errors