Search Postgresql Archives

Re: Rename or Re-Create Constraints?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





Carlos Mennens wrote:
On Fri, Apr 8, 2011 at 8:35 PM, Tom Lane <tgl@xxxxxxxxxxxxx> 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?

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux