| 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-0000Xj-M5@gothos.postgresql.org |
| Views: | Whole Thread | Raw Message | 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
------
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(-)
| 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 |