On 29 May 2011 16:12, Tom Lane wrote:
> Thom Brown writes:
>> On 10 January 2009 19:22, Raymond O'Donnell 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 w
Thom Brown writes:
> On 10 January 2009 19:22, Raymond O'Donnell 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
On 10 January 2009 19:22, Raymond O'Donnell 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 re
That would make more sense wouldn't it. :) Yeah, I think that's the
answer.
Cheers!
Thom
2009/1/10 Raymond O'Donnell
> 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
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"
LI
I can't find anything in the documentation, but does anyone know if there is
a way to rename a constraint?
Thanks
Thom
