Re: Some more information_schema issues

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Some more information_schema issues
Дата
Msg-id 3F8F4649.7070300@familyhealth.com.au
обсуждение исходный текст
Ответ на Some more information_schema issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Some more information_schema issues  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Bison 1.875 for SuSE Linux 8.1?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Some more information_schema issues