Stephen Frost <sfr...@snowman.net> writes: > * Tom Lane (t...@sss.pgh.pa.us) wrote: >> I concur. Let's put the left join(s) into those views and call it >> good.
> I'd suggest we also add some notes to the documentation that the correct > approach to dropping users is to disallow access first, then kill any > existing backends, and then drop the user. That, plus the left joins, > seems like it's good enough. I've pushed Oskari's original patch; a look around in system_views.sql shows that it's justified on the basis of consistency with other views even aside from the functional problem he ran into. The documentation question seems like material for a separate patch. regards, tom lane -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers