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

From David E. Wheeler
Subject Re: creating index names automatically?
Date
Msg-id 5047F34D-A165-4173-A51D-4A70D3012081@kineticode.com
Whole thread Raw
In response to Re: creating index names automatically?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: creating index names automatically?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
On Dec 22, 2009, at 7:31 PM, Tom Lane wrote:

> Wait a minute.  I must have been looking at the wrong keyword list
> --- ON already is reserved.  The problem is exactly that it can't
> tell whether CREATE INDEX CONCURRENTLY ON ... means to default the
> index name or to create an index named CONCURRENTLY.  So really the
> *only* way to fix this is to make CONCURRENTLY be at least
> type_func_name_keyword.

+1 if it prevents indexes from being named "CONCURRENTLY".

Best,

David


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: creating index names automatically?
Next
From: Tom Lane
Date:
Subject: Re: join ordering via Simulated Annealing