Re: idea: storing view source in system catalogs - Mailing list pgsql-hackers

From David Fetter
Subject Re: idea: storing view source in system catalogs
Date
Msg-id 20080520211110.GB25848@fetter.org
Whole thread Raw
In response to idea: storing view source in system catalogs  ("Merlin Moncure" <mmoncure@gmail.com>)
Responses Re: idea: storing view source in system catalogs  (Florian Pflug <fgp.phlo.org@gmail.com>)
Re: idea: storing view source in system catalogs  ("Robert Haas" <robertmhaas@gmail.com>)
List pgsql-hackers
On Tue, May 20, 2008 at 02:03:17PM -0400, Merlin Moncure wrote:
> I wonder if there is any merit to the idea of storing the 'create
> view' statement that created the view in an appropriate place.
> There are basically two reasons for this:

+1 for DDL in general, including the original CREATE and appending all
subsequent ALTERs.  DROP would have to make the thing go away.  I
suppose CREATE OR REPLACE would also wipe the earlier versions, but
I'm not married to to that idea.

Cheers,
David.
-- 
David Fetter <david@fetter.org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david.fetter@gmail.com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate


pgsql-hackers by date:

Previous
From: Sam Mason
Date:
Subject: Re: triggers on prepare, commit, rollback... ?
Next
From: Tom Lane
Date:
Subject: Re: idea: storing view source in system catalogs