Re: bug in information_schema?

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/