public inbox for [email protected]  

help / color / mirror / Atom feed
From: =?utf-8?B?MjU4NzkwNTE5?= <[email protected]>
To: =?utf-8?B?QWRpdHlhIFRvc2huaXdhbA==?= <[email protected]>
To: =?utf-8?B?UmF5IE8nRG9ubmVsbA==?= <[email protected]>
Cc: =?utf-8?B?UGdhZG1pbi1TdXBwb3J0?= <[email protected]>
Subject: Re: Some databases not listed in treeview
Date: Mon, 2 Dec 2024 15:49:42 +0800
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com>
References: <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>
	<CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com>

try to check the scheme name plz

---Original---
From: "Aditya Toshniwal"<[email protected]&gt;
Date: Mon, Dec 2, 2024 11:10 AM
To: "Ray O'Donnell"<[email protected]&gt;;
Cc: "Pgadmin-Support"<[email protected]&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 <[email protected]&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
 [email protected]
 
 
 
 




-- 
Thanks,Aditya Toshniwal

pgAdmin Hacker&nbsp;| Sr. Staff SDE II&nbsp;| 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], [email protected]
  Subject: Re: Some databases not listed in treeview
  In-Reply-To: <[email protected]>

* 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