Re: CREATE IF NOT EXISTS INDEX

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