That would make more sense wouldn't it. :) Yeah, I think that's the answer.
Cheers! Thom 2009/1/10 Raymond O'Donnell <r...@iol.ie> > 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. > > Ray. > > > ------------------------------------------------------------------ > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland > r...@iol.ie > Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals > ------------------------------------------------------------------ >
