Re: Some databases not listed in treeview

From: 258790519 <258790519(at)qq(dot)com>
To: Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com>, Ray O'Donnell <ray(at)rodonnell(dot)ie>
Cc: Pgadmin-Support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Some databases not listed in treeview
Date: 2024-12-02 07:49:42
Message-ID: tencent_FF04E5D512BB4312D344EDC58C999CDF8805@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

try to check the scheme name plz

---Original---
From: "Aditya Toshniwal"<aditya(dot)toshniwal(at)enterprisedb(dot)com&gt;
Date: Mon, Dec 2, 2024 11:10 AM
To: "Ray O'Donnell"<ray(at)rodonnell(dot)ie&gt;;
Cc: "Pgadmin-Support"<pgadmin-support(at)postgresql(dot)org&gt;;
Subject: Re: Some databases not listed in treeview

Hi&nbsp;Ray,

I'm not sure how your DB has an OID of 4 digits. pgAdmin considers all DBs with OIDs less than equal to 16383 as system DBs. So your DB here is considered a system DB.

On Fri, Nov 29, 2024 at 6:32 PM Ray O'Donnell <ray(at)rodonnell(dot)ie&gt; wrote:

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(at)rodonnell(dot)ie



--
Thanks,Aditya Toshniwal

pgAdmin Hacker&nbsp;| Sr. Staff SDE II&nbsp;| enterprisedb.com
"Don't Complain about Heat, Plant a TREE"

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Ray O'Donnell 2024-12-02 10:17:08 Re: Some databases not listed in treeview
Previous Message Pravesh Sharma 2024-12-02 06:54:22 Re: Can I have some help about PgAdmin