| From: | Decibel! <decibel(at)decibel(dot)org> |
|---|---|
| To: | Kevin Kempter <kevin(at)kevinkempterllc(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: rename a constraint? |
| Date: | 2007-09-02 00:04:28 |
| Message-ID: | 20070902000428.GC38801@decibel.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)decibel(dot)org
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Decibel! | 2007-09-02 00:12:33 | Re: pitr replica dies on startup |
| Previous Message | Decibel! | 2007-09-02 00:02:54 | Re: Postgres can be started only when one postgres user is logged in |