Re: CREATE IF NOT EXISTS INDEX

Поиск
Список
Период
Сортировка
От Josh Berkus
Тема Re: CREATE IF NOT EXISTS INDEX
Дата
Msg-id 542B4100.9040000@agliodbs.com
обсуждение исходный текст
Ответ на CREATE IF NOT EXISTS INDEX  (Fabrízio de Royes Mello <fabriziomello@gmail.com>)
Ответы Re: CREATE IF NOT EXISTS INDEX
Список 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 по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: INSERT ... ON CONFLICT {UPDATE | IGNORE}
Следующее
От: Fabrízio de Royes Mello
Дата:
Сообщение: Re: CREATE IF NOT EXISTS INDEX