Re: CREATE IF NOT EXISTS INDEX

Josh Berkus <josh@agliodbs.com> writes:
> On 09/30/2014 02:43 PM, Tom Lane wrote:
>> Fabrízio de Royes Mello <fabriziomello@gmail.com> writes:
>>> What's your thoughts about we implement IF NOT EXISTS for CREATE INDEX?

>> It's got the same semantic problems as every other variant of CINE.

> I do think it should be name-based.

Name-based, eh?  Don't you recall that in modern practice, people
generally don't specify names for indexes at all?  They've usually
got system-generated names, which doesn't seem like a very cool thing
to have scripts depending on.
        regards, tom lane