Horton

Re: Unhappy thoughts about pg_dump and objects inherited from template1

Mark Hollomon <mhh@mindspring.com>

View thread View on postgr.es
From: Mark Hollomon <mhh@mindspring.com>
To: Tom Lane <tgl@sss.pgh.pa.us>, Philip Warner <pjw@rhyme.com.au>
Cc: Jan Wieck <janwieck@Yahoo.com>, pgsql-hackers@postgresql.org
Date: 2000-11-10T03:24:10Z
Lists: 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