pgAdmin III commit: Fix incorrect JOIN in query to list databases - Mailing list pgadmin-hackers

From Magnus Hagander
Subject pgAdmin III commit: Fix incorrect JOIN in query to list databases
Date
Msg-id E1Td1ge-0000Xj-M5@gothos.postgresql.org
Whole thread Raw
List pgadmin-hackers
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(-)


pgadmin-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: pgAdmin III commit: Fix incorrect JOIN in query to list databases
Next
From: Dave Page
Date:
Subject: v1.16.1