Обсуждение: pgAdmin III commit: Fix incorrect JOIN in query to list databases

Поиск
Список
Период
Сортировка

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

От
Magnus Hagander
Дата:
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(-)