Thread: rename a constraint?

rename a constraint?

From
Kevin Kempter
Date:
Hi List;

Is there a method/syntax I can use to rename a constraint ?

Thx

/Kevin

Re: rename a constraint?

From
Decibel!
Date:
On Thu, Aug 30, 2007 at 02:42:43PM -0600, Kevin Kempter wrote:
> Hi List;
>
> Is there a method/syntax I can use to rename a constraint ?

Not an official one, no... you'll need to create a new one then drop the
old (don't do it the other way or it'll have to re-check everything).

You might also be able to UPDATE the appropriate catalog, but I'm not
sure how safe that is.
--
Decibel!, aka Jim Nasby                        decibel@decibel.org
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)

Attachment