Postgres Pro
Downloads
Home   >   mailing lists

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

From Andrew Dunstan
Subject Re: patch: Add columns via CREATE OR REPLACE VIEW
Date
Msg-id 489B2A33.4060601@dunslane.net
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  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 

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.
>
>
>   

How would that look? Where would we put the new query?

cheers

andrew

pgsql-hackers by date:

Previous
From: "Robert Haas"
Date:
Subject: Re: patch: Add columns via CREATE OR REPLACE VIEW
Next
From: "Robert Haas"
Date:
Subject: Re: patch: Add columns via CREATE OR REPLACE VIEW