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

From Tom Lane
Subject Re: creating index names automatically?
Date
Msg-id 3710.1261539067@sss.pgh.pa.us
Whole thread Raw
In response to Re: creating index names automatically?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: creating index names automatically?  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-hackers
I wrote:
> Hmm.  It would actually work if we made CONCURRENTLY reserved instead;
> and that would fix Simon's gripe too.  That's kind of weird from a
> standards-compliance POV, but in terms of the risk of breaking
> applications it might be better than reserving ON.

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.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: creating index names automatically?
Next
From: "David E. Wheeler"
Date:
Subject: Re: creating index names automatically?