Re: patch: Add columns via CREATE OR REPLACE VIEW - Mailing list pgsql-hackers

From David E. Wheeler
Subject Re: patch: Add columns via CREATE OR REPLACE VIEW
Date
Msg-id F3B2AB4B-B58E-4371-BD92-D21402CA7861@kineticode.com
Whole thread Raw
In response to Re: patch: Add columns via CREATE OR REPLACE VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: patch: Add columns via CREATE OR REPLACE VIEW  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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?

Best,

David


pgsql-hackers by date:

Previous
From: "Asko Oja"
Date:
Subject: Re: Avoiding Application Re-test
Next
From: "Robert Haas"
Date:
Subject: Re: patch: Add columns via CREATE OR REPLACE VIEW