Re: template1, can there be a template2/3/4?

From: Jim Mercer <jim(at)reptiles(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: template1, can there be a template2/3/4?
Date: 2001-06-04 19:12:24
Message-ID: 20010604151224.E9538@reptiles.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 04, 2001 at 02:16:35PM -0400, Tom Lane wrote:
> I wrote:
> > Jim Mercer <jim(at)reptiles(dot)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(at)reptiles(dot)org +1 416 410-5633 ]
[ Now with more and longer words for your reading enjoyment. ]

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-06-04 20:12:39 Re: template1, can there be a template2/3/4?
Previous Message Tim Barnard 2001-06-04 18:29:42 Re: libpq and PostgreSQL NOTICEs