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

From Tom Lane
Subject Re: Add column if not exists (CINE)
Date
Msg-id 13579.1272472269@sss.pgh.pa.us
Whole thread Raw
In response to Re: Add column if not exists (CINE)  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers
Robert Haas <robertmhaas@gmail.com> writes:
> Actually, that's a good idea.  But how will you handle tables?

Well, tables are a special case, mainly because it's not clear how to
avoid accidentally throwing away data.  (In particular if some column in
the existing table isn't there in the new definition.  It's a bit scary
to just drop the column, IMO.)  I don't see that that argument applies
to doing an automatic ALTER COLUMN, though, especially since the only
column type alterations that will go through without a USING clause are
reasonably straightforward.
        regards, tom lane


pgsql-hackers by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Differential backup
Next
From: Robert Haas
Date:
Subject: Re: Add column if not exists (CINE)