Re: Unhappy thoughts about pg_dump and objects inherited from template1

Поиск
Список
Период
Сортировка
От Mark Hollomon
Тема Re: Unhappy thoughts about pg_dump and objects inherited from template1
Дата
Msg-id 00110922241000.00334@jupiter
обсуждение исходный текст
Ответ на Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Philip Warner <pjw@rhyme.com.au>)
Список pgsql-hackers
On Wednesday 08 November 2000 10:15, Tom Lane wrote:
> > At 14:04 7/11/00 -0500, Jan Wieck wrote:
> >> FWIW,  what  about having another "template0" database, where
> >> nobody can add user data. Initially, template0 and  template1
> >> are identically.  CREATE DATABASE get's a new switch (used by
> >> the pg_dump output) that tells to create it from the  vanilla
> >> template0  DB  (generalized, so someone can setup a couple of
> >> template<n>'s)  and  all  objects  inherited  from  template1
> >> (those not in template0) are regularly dumped per database.
>
> I like that a lot.  Solves the whole problem at a stroke, and even
> adds some extra functionality (alternate templates).
>

How does this solve the 'ALTER FUNCTION' problem?

-- 
Mark Hollomon


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 7.0.2 dies when connection dropped mid-transaction
Следующее
От: Tom Lane
Дата:
Сообщение: Re: 7.0.2 dies when connection dropped mid-transaction