Re: bug in information_schema? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: bug in information_schema?
Date
Msg-id 200508011042.10990.peter_e@gmx.net
Whole thread Raw
In response to Re: bug in information_schema?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: "Dinesh Pandey"
Date:
Subject: How to connect ORACLE database from Postgres function using plpgsql/pltclu?
Next
From: Dawid Kuroczko
Date:
Subject: Re: How to connect ORACLE database from Postgres function using plpgsql/pltclu?