pgAdmin III commit: Fix incorrect JOIN in query to list databases

From: Magnus Hagander <magnus(at)hagander(dot)net>
To: pgadmin-hackers(at)postgresql(dot)org
Subject: pgAdmin III commit: Fix incorrect JOIN in query to list databases
Date: 2012-11-26 16:37:36
Message-ID: E1Td1ge-0000Xh-Lf@gothos.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
------
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(-)

Browse pgadmin-hackers by date

  From Date Subject
Next Message Dave Page 2012-11-26 18:44:28 v1.16.1
Previous Message Dave Page 2012-11-26 13:26:47 Re: [Patch] Data type cache to speed up query tool