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

From Josh Berkus
Subject Re: CREATE IF NOT EXISTS INDEX
Date
Msg-id 542B4100.9040000@agliodbs.com
Whole thread Raw
In response to CREATE IF NOT EXISTS INDEX  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Responses Re: CREATE IF NOT EXISTS INDEX
List pgsql-hackers
On 09/30/2014 04:16 PM, Andres Freund wrote:
> On 2014-09-30 16:03:01 -0700, Josh Berkus wrote:
>> On 09/30/2014 03:53 PM, Andres Freund wrote:
>>> Good point. I think it's fair enough to only allow CINE on named
>>> indexes.
>>
>> On the other hand, the way we form system-generated names is predicable,
>> so I think it would be perfectly OK to include them.  Desirable, in fact.
> 
> It's not really that predicable. Think about expression indexes. They
> also don't contain information about opclasses et all.
> 
> Seems like pit of hairy semantics.
> 
>> Not that I'm a fan of omitting the name ...
> 
> Me neither.

I'd be OK with a CINE which required you to name the index.

How does your patch work at present, Fabrizio?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Next
From: Fabrízio de Royes Mello
Date:
Subject: Re: CREATE IF NOT EXISTS INDEX