Skip site navigation (1) Skip section navigation (2)

Re: Rename a constraint

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thom Brown <thombrown(at)gmail(dot)com>
Cc: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>, rod(at)iol(dot)ie, Bruce Momjian <bruce(at)momjian(dot)us>
Subject: Re: Rename a constraint
Date: 2011-05-29 15:12:44
Message-ID: 20376.1306681964@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-general
Thom Brown <thombrown(at)gmail(dot)com> writes:
> On 10 January 2009 19:22, Raymond O'Donnell <rod(at)iol(dot)ie> wrote:
>> On 10/01/2009 19:15, Thom Brown wrote:
>>> I can't find anything in the documentation, but does anyone know if
>>> there is a way to rename a constraint?

>> I just tried it with a primary key...
>> 
>> test=# alter table t1 alter constraint t1_pk rename to t1_pp;
>> ERROR: syntax error at or near "constraint"
>> LINE 1: alter constraint t1_pk rename to t1_pp;
>> 
>> ... and as you can see it didn't work. I suppose you could always drop
>> and recreate it with a different name.

> While this was a sufficient solution for the problem I was having back
> then, it will be problematic for those with large tables as it means
> re-validating the constraint against the entire table.

Use ALTER INDEX RENAME to rename the index underlying the constraint.
The constraint will follow along.

			regards, tom lane

In response to

Responses

pgsql-general by date

Next:From: Thom BrownDate: 2011-05-29 15:24:32
Subject: Re: Rename a constraint
Previous:From: Thom BrownDate: 2011-05-29 13:20:54
Subject: Re: Rename a constraint

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group