Thom Brown <thombrown@xxxxxxxxx> writes: > On 10 January 2009 19:22, Raymond O'Donnell <rod@xxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
