Re: rename constraint - Mailing list pgsql-performance

From Thomas Spreng
Subject Re: rename constraint
Date
Msg-id C4496A86-3F18-4ACA-8640-6DD98E2A4AC1@socket.ch
Whole thread Raw
In response to rename constraint  ("sathiya psql" <sathiya.psql@gmail.com>)
List pgsql-performance
On 17.04.2008, at 14:03, sathiya psql wrote:
> Hi,
>
> I need to change the name of the constraint.,
>
> Or i need to drop the constraint, and i need to create constraint
> with new
> name, how the impact of this in performance, because these constraint
> changes am going to do in a table which has 10 million records....

That's how I would do it, create the new constriaint, then drop the
old one.
I'n not aware of any syntax that would allow to rename a constraint.

Cheers,

tom


pgsql-performance by date:

Previous
From: "sathiya psql"
Date:
Subject: rename constraint
Next
From: Gunther Mayer
Date:
Subject: Re: Exact index overhead