Some databases not listed in treeview

Поиск
Список
Период
Сортировка
От Ray O'Donnell
Тема Some databases not listed in treeview
Дата
Msg-id 01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com
обсуждение исходный текст
Ответы Re: Some databases not listed in treeview
Список pgadmin-support
Hi all,

I've just come across a funny in pgAdmin 4 version 8.13: when I connect 
from my laptop to a server on the same laptop, not all databases are 
listed in the tree-view on the left. The server is PostgreSQL 16.6.

Connecting to the server with psql and doing \l shows me 12 databases, 
including template0 and template1. Likewise, "select * from pg_database" 
gives me the same 12 rows. However, the treeview shows only 9... 
template* databases are excluded, plus one other of my own.

Interestingly, when I select from pg_database, the one database of mine 
which is excluded has an OID of 4; all the others have 5-digit OIDs. I 
don't know why its OID is so low; it's come forward through a few PG 
versions over several years, so probably historical baggage.

All the best,

Ray.

-- 
Raymond O'Donnell // Galway // Ireland
ray@rodonnell.ie




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