Re: RFD: schemas and different kinds of Postgres objects

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fernando Nasser <fnasser(at)redhat(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: RFD: schemas and different kinds of Postgres objects
Date: 2002-01-22 21:14:16
Message-ID: 28557.1011734056@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Fernando Nasser <fnasser(at)redhat(dot)com> writes:
> Switches set to historical:

> schema search path = (user's own schema, "any" schema, postgres)

> [ default creation schema = user's own schema ]

> The searching in "any" schema (i.e., any owner) will let will find
> things that where defined the way they are today, i.e., possibly
> by several different users.

No, it won't, because nothing will ever get put into that schema.
(At least not by existing pg_dump scripts, which are the things that
really need to see the historical behavior.) The
default-creation-schema variable has got to point at any/public/
whatever-we-call it, or you do not have the historical behavior.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-01-22 21:16:12 Re: TODO question and claim
Previous Message Fernando Nasser 2002-01-22 21:02:07 Re: RFD: schemas and different kinds of Postgres objects