Re: Renaming constraints

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Kalsch <andreaskalsch(at)gmx(dot)de>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Renaming constraints
Date: 2009-10-08 20:07:25
Message-ID: 7567.1255032445@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Andreas Kalsch <andreaskalsch(at)gmx(dot)de> writes:
> But with this operation you will recreate the whole index. - I have
> found out, that the name of the constraint's index is the same as the
> constraint, so that I can simply rename the index.

You'd probably better rename the constraint too to avoid confusion.
Failing anything else, there's always direct UPDATE of the pg_constraint
catalog.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2009-10-08 20:20:32 Re: Renaming constraints
Previous Message Emanuel Calvo Franco 2009-10-08 20:01:38 Re: Query inside RTF