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

From Tom Lane
Subject Re: template1, can there be a template2/3/4?
Date
Msg-id 6618.991678595@sss.pgh.pa.us
Whole thread Raw
In response to template1, can there be a template2/3/4?  (Jim Mercer <jim@reptiles.org>)
Responses Re: template1, can there be a template2/3/4?  (Jim Mercer <jim@reptiles.org>)
List pgsql-general
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.

            regards, tom lane

pgsql-general by date:

Previous
From: "Tim Barnard"
Date:
Subject: libpq and PostgreSQL NOTICEs
Next
From: "Tim Barnard"
Date:
Subject: Re: libpq and PostgreSQL NOTICEs