Re: idea: storing view source in system catalogs

Поиск
Список
Период
Сортировка
От David Fetter
Тема Re: idea: storing view source in system catalogs
Дата
Msg-id 20080520211110.GB25848@fetter.org
обсуждение исходный текст
Ответ на idea: storing view source in system catalogs  ("Merlin Moncure" <mmoncure@gmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Sam Mason
Дата:
Сообщение: Re: triggers on prepare, commit, rollback... ?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: idea: storing view source in system catalogs