Re: Schema bug - Mailing list pgadmin-hackers

From Jim C. Nasby
Subject Re: Schema bug
Date
Msg-id 20051212233754.GM54639@decibel.org
Whole thread Raw
In response to Re: Schema bug  ("Florian G. Pflug" <fgp@phlo.org>)
List pgadmin-hackers
FWIW, here's what we ended up going with in newsysviews:

create or replace function _pg_sv_system_schema(name) returns boolean
  as 'select $1 in (name ''pg_catalog'', name ''pg_toast'',
                    name ''pg_sysviews'', name ''information_schema'')'
  language sql immutable strict;

This was after someone dug into pg_dump to see what it considers a
system schema (AndrewSN I believe).

On Tue, Dec 13, 2005 at 12:29:01AM +0100, Florian G. Pflug wrote:
> Andreas Pflug wrote:
> > Florian G. Pflug wrote:
> >> I'd prefer system-catalogs being excluded by name - preferably the
> >> exclusion-list would be editable, and part of the pgadmin preferences.
> >> Seems more transparent to me - and future-proof, in the sense that
> >> even if a future postgres version chooses to rename some catalog, the
> >> user will be able to just add the new names to the exclusion list.
> >
> > There's already a database restriction and a schema restriction, just
> > use it.
> Ups... Should have checked before posting... Doesn't invalidate my
> point, though ;-)
>
> BTW, I just checked the postgresql CVS, and found the in the beginnings
> of schema-support in pgsql, the public schema had oid 2071. It got
> changed to 2200 before 7.3 was released, though.
>
> greetings, Florian Pflug
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

--
Jim C. Nasby, Database Architect                decibel@decibel.org
Give your computer some brain candy! www.distributed.net Team #1828

Windows: "Where do you want to go today?"
Linux: "Where do you want to go tomorrow?"
FreeBSD: "Are you guys coming, or what?"

pgadmin-hackers by date:

Previous
From: "Florian G. Pflug"
Date:
Subject: Re: Schema bug
Next
From: Guillaume LELARGE
Date:
Subject: Re: Schema bug