public inbox for [email protected]
help / color / mirror / Atom feedSome databases not listed in treeview
4+ messages / 3 participants
[nested] [flat]
* Some databases not listed in treeview
@ 2024-11-29 13:01 Ray O'Donnell <[email protected]>
0 siblings, 1 reply; 4+ messages in thread
From: Ray O'Donnell @ 2024-11-29 13:01 UTC (permalink / raw)
To: 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
[email protected]
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Some databases not listed in treeview
@ 2024-12-02 03:10 Aditya Toshniwal <[email protected]>
parent: Ray O'Donnell <[email protected]>
0 siblings, 2 replies; 4+ messages in thread
From: Aditya Toshniwal @ 2024-12-02 03:10 UTC (permalink / raw)
To: Ray O'Donnell <[email protected]>; +Cc: pgadmin-support
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"
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Some databases not listed in treeview
@ 2024-12-02 07:49 =?utf-8?B?MjU4NzkwNTE5?= <[email protected]>
parent: Aditya Toshniwal <[email protected]>
1 sibling, 0 replies; 4+ messages in thread
From: =?utf-8?B?MjU4NzkwNTE5?= @ 2024-12-02 07:49 UTC (permalink / raw)
To: =?utf-8?B?QWRpdHlhIFRvc2huaXdhbA==?= <[email protected]>; =?utf-8?B?UmF5IE8nRG9ubmVsbA==?= <[email protected]>; +Cc: pgadmin-support
try to check the scheme name plz
---Original---
From: "Aditya Toshniwal"<[email protected]>
Date: Mon, Dec 2, 2024 11:10 AM
To: "Ray O'Donnell"<[email protected]>;
Cc: "Pgadmin-Support"<[email protected]>;
Subject: Re: Some databases not listed in treeview
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
"Don't Complain about Heat, Plant a TREE"
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Some databases not listed in treeview
@ 2024-12-02 10:17 Ray O'Donnell <[email protected]>
parent: Aditya Toshniwal <[email protected]>
1 sibling, 0 replies; 4+ messages in thread
From: Ray O'Donnell @ 2024-12-02 10:17 UTC (permalink / raw)
To: Aditya Toshniwal <[email protected]>; +Cc: 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 <[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"
--
Raymond O'Donnell // Galway // Ireland
[email protected]
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2024-12-02 10:17 UTC | newest]
Thread overview: 4+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-11-29 13:01 Some databases not listed in treeview Ray O'Donnell <[email protected]>
2024-12-02 03:10 ` Aditya Toshniwal <[email protected]>
2024-12-02 07:49 ` =?utf-8?B?MjU4NzkwNTE5?= <[email protected]>
2024-12-02 10:17 ` Ray O'Donnell <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox