Re: template1, can there be a template2/3/4? - Mailing list pgsql-general

From Jim Mercer
Subject Re: template1, can there be a template2/3/4?
Date
Msg-id 20010604151224.E9538@reptiles.org
Whole thread Raw
In response to Re: template1, can there be a template2/3/4?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: template1, can there be a template2/3/4?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Mon, Jun 04, 2001 at 02:16:35PM -0400, Tom Lane wrote:
> I wrote:
> > Jim Mercer <jim@reptiles.org> writes:
> >> where are these relations?  is this a compile-time thing, or can it be done
> >> on-the-fly?
>
> > Compile-time; see SharedSystemRelationNames in
> > backend/utils/init/globals.c.  You'd have to do an initdb after changing
> > it, anyway.
>
> BTW, the reason that pg_shadow is installation-wide is that it's
> not real clear what the 'ownership' column in pg_database means
> if users are not installation-wide.  Before cutting and hacking,
> you'd need to think carefully about just what semantics you are
> really after.

theoretically, if i nuked everything from SharedSystemRelationNames, then
each database would be wholly stand-alone, and the remaining code should just
work?


--
[ Jim Mercer        jim@reptiles.org         +1 416 410-5633 ]
[ Now with more and longer words for your reading enjoyment. ]

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: template1, can there be a template2/3/4?
Next
From: Tom Lane
Date:
Subject: Re: template1, can there be a template2/3/4?