public inbox for [email protected]
help / color / mirror / Atom feedFrom: Aditya Toshniwal <[email protected]>
To: Ray O'Donnell <[email protected]>
Cc: Pgadmin-Support <[email protected]>
Subject: Re: Some databases not listed in treeview
Date: Mon, 2 Dec 2024 08:40:01 +0530
Message-ID: <CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com> (raw)
In-Reply-To: <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>
References: <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>
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 <[email protected]> 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
> [email protected]
>
>
>
>
--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/;
"Don't Complain about Heat, Plant a TREE"
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], [email protected]
Subject: Re: Some databases not listed in treeview
In-Reply-To: <CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.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