Skip site navigation (1) Skip section navigation (2)

Re: BUG #6734: create table (like ...) fails if an index has a comment

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com>
Cc: Ryan Kelly <rpkelly22(at)gmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6734: create table (like ...) fails if an index has a comment
Date: 2012-07-13 15:11:41
Message-ID: 1522.1342192301@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)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.

			regards, tom lane

In response to

Responses

pgsql-bugs by date

Next:From: Craig RingerDate: 2012-07-13 15:15:55
Subject: Re: BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied
Previous:From: Tom LaneDate: 2012-07-13 15:05:59
Subject: Re: BUG #6734: create table (like ...) fails if an index has a comment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group