Re: information_schema OID - Mailing list pgsql-hackers

From Tom Lane
Subject Re: information_schema OID
Date
Msg-id 24447.1052279621@sss.pgh.pa.us
Whole thread Raw
In response to Re: information_schema OID  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
"Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> Also, should the information_schema be pinned so that it cannot be dropped?

Why?  Sure, the DBA had better be damn certain that he wants to do that
before he does it.  But we let superusers drop lots of things that they
would be better advised not to.  If someone wants a small disk footprint
I can imagine a good case for feeling that information_schema is useless.

> This would help db admin projects such as phpPgAdmin be able to rely on
> information_schema being there...

Rely away.  It's not your business to work in databases that a superuser
has made arbitrary changes to.  Do you claim to still work if he renames
the integer "=" operator to "!#&@!!" ?
        regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Installin Postgres
Next
From: Tom Lane
Date:
Subject: Re: 7.4 features list