Fix incorrect JOIN in query to list databases The join to pg_shdescription needs to include the object class of the description, or it will return the same database multiple times for example when there is both a database and a user with the same oid, both having description. This can happen either when oid wraparound has happened in the server, or when pg_upgrade has been used (since pg_upgrade doesn't preserve database oid's, they can be reused in the same space as pg_authid)
Branch ------ master Details ------- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=1a786b503707e43f83790ed4449309cf55c2f65c Modified Files -------------- CHANGELOG | 1 + pgadmin/schema/pgDatabase.cpp | 2 +- 2 files changed, 2 insertions(+), 1 deletions(-) -- Sent via pgadmin-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-hackers
