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 ------ REL-1_16_0_PATCHES Details ------- http://git.postgresql.org/gitweb?p=pgadmin3.git;a=commitdiff;h=808478e48f17c88228c6434ebc064d3ac54147e5 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
