Re: Renaming constraints - Mailing list pgsql-general

From Tom Lane
Subject Re: Renaming constraints
Date
Msg-id 7567.1255032445@sss.pgh.pa.us
Whole thread Raw
In response to Re: Renaming constraints  (Andreas Kalsch <andreaskalsch@gmx.de>)
Responses Re: Renaming constraints
Using pg_catalog to define things across schemas
List pgsql-general
Andreas Kalsch <andreaskalsch@gmx.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

pgsql-general by date:

Previous
From: Emanuel Calvo Franco
Date:
Subject: Re: Query inside RTF
Next
From: Thom Brown
Date:
Subject: Re: Renaming constraints