pg.ddx.io pgsql-hackers@postgresql.org mailing list archive
help / color / mirror / Atom feedinformation_schema OID
4+ messages / 4 participants
[nested] [flat]
* information_schema OID
@ 2003-05-06 19:27 Andreas Pflug <Andreas.Pflug@web.de>
2003-05-07 01:51 ` Re: information_schema OID Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-05-07 18:38 ` Re: information_schema OID Peter Eisentraut <peter_e@gmx.net>
0 siblings, 2 replies; 4+ messages in thread
From: Andreas Pflug @ 2003-05-06 19:27 UTC (permalink / raw)
To: 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?
Regards,
Andreas
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: information_schema OID
2003-05-06 19:27 information_schema OID Andreas Pflug <Andreas.Pflug@web.de>
@ 2003-05-07 01:51 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-05-07 03:53 ` Re: information_schema OID Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 4+ messages in thread
From: Christopher Kings-Lynne @ 2003-05-07 01:51 UTC (permalink / raw)
To: Andreas Pflug <Andreas.Pflug@web.de>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: information_schema OID
2003-05-06 19:27 information_schema OID Andreas Pflug <Andreas.Pflug@web.de>
2003-05-07 01:51 ` Re: information_schema OID Christopher Kings-Lynne <chriskl@familyhealth.com.au>
@ 2003-05-07 03:53 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2003-05-07 03:53 UTC (permalink / raw)
To: Christopher Kings-Lynne <chriskl@familyhealth.com.au>; +Cc: Andreas Pflug <Andreas.Pflug@web.de>; 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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: information_schema OID
2003-05-06 19:27 information_schema OID Andreas Pflug <Andreas.Pflug@web.de>
@ 2003-05-07 18:38 ` Peter Eisentraut <peter_e@gmx.net>
1 sibling, 0 replies; 4+ messages in thread
From: Peter Eisentraut @ 2003-05-07 18:38 UTC (permalink / raw)
To: Andreas Pflug <Andreas.Pflug@web.de>; +Cc: pgsql-hackers
Andreas Pflug writes:
> How should pgadmin3 handle this? Will information_schema eventually get
> a dedicated OID or should we check for the name?
Check the name, as you should for all system objects.
--
Peter Eisentraut peter_e@gmx.net
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-05-07 18:38 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-06 19:27 information_schema OID Andreas Pflug <Andreas.Pflug@web.de>
2003-05-07 01:51 ` Christopher Kings-Lynne <chriskl@familyhealth.com.au>
2003-05-07 03:53 ` Tom Lane <tgl@sss.pgh.pa.us>
2003-05-07 18:38 ` Peter Eisentraut <peter_e@gmx.net>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox