Skip site navigation (1) Skip section navigation (2)

Re: Schema bug

From: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
To: "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>
Cc: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>,Dave Page <dpage(at)vale-housing(dot)co(dot)uk>,Guillaume LELARGE <guillaume(dot)lelarge(at)gmail(dot)com>,pgadmin-hackers(at)postgresql(dot)org
Subject: Re: Schema bug
Date: 2005-12-12 23:37:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: 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(at)decibel(dot)org 
Give your computer some brain candy! 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?"

In response to

pgadmin-hackers by date

Next:From: Guillaume LELARGEDate: 2005-12-12 23:48:55
Subject: Re: Schema bug
Previous:From: Florian G. PflugDate: 2005-12-12 23:29:01
Subject: Re: Schema bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group