On Fri, Jul 13, 2012 at 4:11 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > Daniele Varrazzo <daniele.varra...@gmail.com> writes: >> Wouldn't it be better to call the indexes NEWTABLE_OLDINDEXNAME? > > Then the CREATE LIKE command would fail altogether if that name were > already taken. Postponing the selection of the index name to the time > when DefineIndex runs is really the only safe thing.
I've actually suggested to keep the numeric suffix to disambiguate in case the name is already taken, as I assume the current "create like" does. However this is not strictly related to the bug, it's more an usability problem, so won't bother you with it anymore. -- Daniele -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs