Re: information_schema OID - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: information_schema OID
Date
Msg-id 074701c3143b$235dc640$6500a8c0@fhp.internal
Whole thread Raw
In response to information_schema OID  (Andreas Pflug <Andreas.Pflug@web.de>)
Responses Re: information_schema OID  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> As information_schema has found its way into the initdb script, it can
> be considered a system schema. Unfortunately, it has an arbitrary OID,
> so pgadmin3 will not detect it as system schema.
> How should pgadmin3 handle this? Will information_schema eventually get
> a dedicated OID or should we check for the name?

Also, should the information_schema be pinned so that it cannot be dropped?
This would help db admin projects such as phpPgAdmin be able to rely on
information_schema being there...

Chris



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: 7.4 features list
Next
From: Barry Lind
Date:
Subject: Re: 7.4 features list