Re: Some more information_schema issues - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: Some more information_schema issues
Date
Msg-id 3F8F4649.7070300@familyhealth.com.au
Whole thread Raw
In response to Some more information_schema issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Some more information_schema issues
List pgsql-hackers
> I looked through all the information_schema stuff, and found a few more
> nits.

I notice that most of the references in the information_schema.sql are 
not schema-qualfied.

eg:

FROM (pg_namespace ncon INNER JOIN pg_constraint con ON ncon.oid

Shouldn't that be:

FROM (pg_catalog.pg_namespace ncon INNER JOIN pg_catalog.pg_constraint ..

Because what I'm concerned about is that if my personal schema (chriskl) 
has a table called 'pg_catalog' or a function called '_pg_keysequal', 
then if I go 'SELECT * FROM INFORMATIONS_SCHEMA.someview', then it will 
break?

Chris




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bison 1.875 for SuSE Linux 8.1?
Next
From: Tom Lane
Date:
Subject: Re: Some more information_schema issues