From: | Ray O'Donnell <ray(at)rodonnell(dot)ie> |
---|---|
To: | Aditya Toshniwal <aditya(dot)toshniwal(at)enterprisedb(dot)com> |
Cc: | Pgadmin-Support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Some databases not listed in treeview |
Date: | 2024-12-02 10:17:08 |
Message-ID: | 0102019386dfb4c8-8c5f5150-59fe-4c09-9383-80c4aca64aec-000000@eu-west-1.amazonses.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Helo Aditya,
Thanks for responding. I've no idea how that happened either! Anyway,
I'm glad to know what the issue is - thanks for clarifying.
Ray.
On 02/12/2024 03:10, Aditya Toshniwal wrote:
> Hi 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> 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 | Sr. Staff SDE II |*enterprisedb.com*
> <https://www.enterprisedb.com/>
> "Don't Complain about Heat, Plant a TREE"
--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2024-12-02 10:19:06 | Re: password to SQL Shell (psql) |
Previous Message | 258790519 | 2024-12-02 07:49:42 | Re: Some databases not listed in treeview |