Postgres Pro
Downloads
Home   >   mailing lists

Re: creating index names automatically? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: creating index names automatically?
Date
Msg-id 4081.1261540475@sss.pgh.pa.us
Whole thread Raw
In response to Re: creating index names automatically?  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: creating index names automatically?  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> David E. Wheeler wrote:
>> +1 if it prevents indexes from being named "CONCURRENTLY".

> Yeah, if you really want to have an index named like that you can use
> double quotes.  Seems a sensible compromise.

Well, this will also break tables and columns named "concurrently".
I think the odds of it being a problem are small, but still it is
a reserved word that shouldn't be reserved according to the SQL spec.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: creating index names automatically?
Next
From: Heikki Linnakangas
Date:
Subject: Re: Tuplestore should remember the memory context it's created in