Re: patch: Add columns via CREATE OR REPLACE VIEW

From: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: patch: Add columns via CREATE OR REPLACE VIEW
Date: 2008-08-07 16:52:51
Message-ID: F3B2AB4B-B58E-4371-BD92-D21402CA7861@kineticode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2008-08-07 16:56:24 Re: patch: Add columns via CREATE OR REPLACE VIEW
Previous Message Asko Oja 2008-08-07 16:47:16 Re: Avoiding Application Re-test