Re: Unhappy thoughts about pg_dump and objects inherited from template1 - Mailing list pgsql-hackers

From Mark Hollomon
Subject Re: Unhappy thoughts about pg_dump and objects inherited from template1
Date
Msg-id 00110922241000.00334@jupiter
Whole thread Raw
In response to Re: Unhappy thoughts about pg_dump and objects inherited from template1  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Unhappy thoughts about pg_dump and objects inherited from template1
Re: Unhappy thoughts about pg_dump and objects inherited from template1
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: 7.0.2 dies when connection dropped mid-transaction
Next
From: Tom Lane
Date:
Subject: Re: 7.0.2 dies when connection dropped mid-transaction