Re: Add column if not exists (CINE) - Mailing list pgsql-hackers

From Robert Haas
Subject Re: Add column if not exists (CINE)
Date
Msg-id AANLkTimsOHQWPTapjgxowMmLfzZr3Mw9L1-Z58fVW7u6@mail.gmail.com
Whole thread Raw
In response to Re: Add column if not exists (CINE)  (Kjell Rune Skaaraas <kjella79@yahoo.no>)
List 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 by date:

Previous
From: Robert Haas
Date:
Subject: Re: Add column if not exists (CINE)
Next
From: Adriano Lange
Date:
Subject: Re: TwoPO: experimental join order algorithm