Re: rename a constraint? - Mailing list pgsql-admin

From Decibel!
Subject Re: rename a constraint?
Date
Msg-id 20070902000428.GC38801@decibel.org
Whole thread Raw
In response to rename a constraint?  (Kevin Kempter <kevin@kevinkempterllc.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Decibel!
Date:
Subject: Re: Postgres can be started only when one postgres user is logged in
Next
From: Decibel!
Date:
Subject: Re: pitr replica dies on startup