Re: patch: Add columns via CREATE OR REPLACE VIEW

"David E. Wheeler" <david@kineticode.com> writes:
> On Aug 7, 2008, at 08:43, Tom Lane wrote:
>> Maybe the right way is to *not* use CREATE OR REPLACE VIEW, but
>> rather ALTER VIEW ADD COLUMN and so on.  Then column identity seems
>> a lot easier to keep track of.

> +1, although what does the standard say?

AFAICT the standard doesn't have any way to alter the definition of an
existing view at all.  It might be worth asking what other systems do,
though --- can you alter a view in Oracle or DB2 or mysql?
        regards, tom lane