Re: Add column if not exists (CINE)

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: Add column if not exists (CINE)
Дата
Msg-id AANLkTimsOHQWPTapjgxowMmLfzZr3Mw9L1-Z58fVW7u6@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Add column if not exists (CINE)  (Kjell Rune Skaaraas <kjella79@yahoo.no>)
Список pgsql-hackers
On Thu, Jul 22, 2010 at 4:34 PM, Kjell Rune Skaaraas <kjella79@yahoo.no> wrote:
> At least from a performance point of view CINE should never cause a table rewrite, it should either execute as a
plainCREATE or as "nothing". I don't mind if the CINE fails if the column already exists but with a different
definition,so maybe it could be worded differently to make it clearer what you get? 

That's what I want, too.  The people saying we should implement COR
for columns seem to be, by and large, people who have never wished for
this feature and have no particular use case for either one.  I have
stated my use case in the past, but it has been dismissed as stupid or
contrived.  I can live with the possibility that I'm dumb, but, for
the record, I'm not making this up.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: Add column if not exists (CINE)
Следующее
От: Adriano Lange
Дата:
Сообщение: Re: TwoPO: experimental join order algorithm