Thom Brown <[email protected]> writes:
> On 10 January 2009 19:22, Raymond O'Donnell <[email protected]> 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
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
