Re: bug in information_schema?

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: bug in information_schema?
Дата
Msg-id 200508011042.10990.peter_e@gmx.net
обсуждение исходный текст
Ответ на Re: bug in information_schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-sql
Am Samstag, 30. Juli 2005 17:15 schrieb Tom Lane:
> The unconstrained join against pg_user is clearly unnecessary,
> and in fact I took it out a few days ago.  I'm not sure whether the
> SELECT DISTINCT is still needed --- it might be, if there can be
> multiple pg_depend entries linking the same entities.

That would have been my guess, but it seems that even if a column or table is 
used multiple times, a dependency is recorded only once, as it should be.  It 
might have been related to the duplicate pg_user mention.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Dinesh Pandey"
Дата:
Сообщение: How to connect ORACLE database from Postgres function using plpgsql/pltclu?
Следующее
От: Dawid Kuroczko
Дата:
Сообщение: Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu?