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/ ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings