public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ray O'Donnell <[email protected]>
To: Pgadmin-Support <[email protected]>
Subject: Some databases not listed in treeview
Date: Fri, 29 Nov 2024 13:01:52 +0000
Message-ID: <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com> (raw)

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
[email protected]

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Some databases not listed in treeview
  In-Reply-To: <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox