Re: [HACKERS] Unhappy thoughts about pg_dump and objects inherited from template1

[Mark Hollomon]

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