Carlos Mennens wrote:
> On Fri, Apr 8, 2011 at 8:35 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>
>> I believe you can rename the underlying indexes and the constraints will
>> follow them. (This works in HEAD anyway, not sure how far back.)
>>
>
> I'm sorry but I don't understand what that means or how to relate that
> to a SQL command to rename the constraint. Do you have an example of
> how that command would look?
>
>
>>> 2. When renaming the table, is there a way to rename both the table
>>> and all associated constraints?
>>>
>> No, there's nothing automatic for that. IIRC there used to be code to
>> try to do this when you renamed a single column; but we took it out,
>> probably because it risked unexpected failures due to index name
>> collisions.
>>
>> regards, tom lane
>>
>>
I wonder if OP wouldn't be best advised to externalize his DDL where by
simple editing would take care of the issue?