| From: | David Fetter <david(at)fetter(dot)org> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: idea: storing view source in system catalogs |
| Date: | 2008-05-20 21:11:10 |
| Message-ID: | 20080520211110.GB25848@fetter.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-05-20 22:58:45 | Re: idea: storing view source in system catalogs |
| Previous Message | Sam Mason | 2008-05-20 18:51:32 | Re: triggers on prepare, commit, rollback... ? |