| From: | Mark Hollomon <mhh(at)mindspring(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Philip Warner <pjw(at)rhyme(dot)com(dot)au> |
| Cc: | Jan Wieck <janwieck(at)Yahoo(dot)com>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Unhappy thoughts about pg_dump and objects inherited from template1 |
| Date: | 2000-11-10 03:24:10 |
| Message-ID: | 00110922241000.00334@jupiter |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | The Hermit Hacker | 2000-11-10 03:40:17 | Re: 7.0.2 dies when connection dropped mid-transaction |
| Previous Message | Alfred Perlstein | 2000-11-10 03:01:17 | Re: 7.0.2 dies when connection dropped mid-transaction |