Re: CREATE IF NOT EXISTS INDEX - Mailing list pgsql-hackers

From Tom Lane
Subject Re: CREATE IF NOT EXISTS INDEX
Date
Msg-id 23573.1412117244@sss.pgh.pa.us
Whole thread Raw
In response to Re: CREATE IF NOT EXISTS INDEX  (Josh Berkus <josh@agliodbs.com>)
Responses Re: CREATE IF NOT EXISTS INDEX
List pgsql-hackers
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



pgsql-hackers by date:

Previous
From: Fabrízio de Royes Mello
Date:
Subject: Re: CREATE IF NOT EXISTS INDEX
Next
From: Andres Freund
Date:
Subject: Re: CREATE IF NOT EXISTS INDEX