Carlos Mennens <carlos.mennens@xxxxxxxxx> writes: > 1. Do I need to remove all the table constraints or is there a way to > rename them? I believe you can rename the underlying indexes and the constraints will follow them. (This works in HEAD anyway, not sure how far back.) > 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
