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

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема pgAdmin III commit: Fix incorrect JOIN in query to list databases
Дата
Msg-id E1Td1ge-0000Xh-Lf@gothos.postgresql.org
обсуждение исходный текст
Список 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(-)


В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: [Patch] Data type cache to speed up query tool
Следующее
От: Magnus Hagander
Дата:
Сообщение: pgAdmin III commit: Fix incorrect JOIN in query to list databases