MIME-Version: 1.0
References: 
 <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>
In-Reply-To: 
 <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>
From: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Date: Mon, 2 Dec 2024 08:40:01 +0530
Message-ID: 
 <CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com>
Subject: Re: Some databases not listed in treeview
To: "Ray O'Donnell" <ray@rodonnell.ie>
Cc: Pgadmin-Support <pgadmin-support@postgresql.org>
Content-Type: multipart/alternative; boundary="00000000000085941a062840e41e"
Archived-At: 
 <https://www.postgresql.org/message-id/CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ%40mail.gmail.com>
Precedence: bulk

--00000000000085941a062840e41e
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

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=E2=80=AFPM Ray O'Donnell <ray@rodonnell.ie> wr=
ote:

> 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@rodonnell.ie
>
>
>
>

--=20
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Staff SDE II | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"

--00000000000085941a062840e41e
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div class=3D"gmail_default" style=3D"font-family:verdana,=
sans-serif">Hi=C2=A0Ray,</div><div class=3D"gmail_default" style=3D"font-fa=
mily:verdana,sans-serif"><br></div><div class=3D"gmail_default" style=3D"fo=
nt-family:verdana,sans-serif">I&#39;m not sure how your DB has an OID of 4 =
digits. pgAdmin considers all DBs with OIDs less than equal to 16383 as sys=
tem DBs. So your DB here is considered a system DB.</div></div><br><div cla=
ss=3D"gmail_quote"><div dir=3D"ltr" class=3D"gmail_attr">On Fri, Nov 29, 20=
24 at 6:32=E2=80=AFPM Ray O&#39;Donnell &lt;<a href=3D"mailto:ray@rodonnell=
.ie">ray@rodonnell.ie</a>&gt; wrote:<br></div><blockquote class=3D"gmail_qu=
ote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,20=
4);padding-left:1ex">Hi all,<br>
<br>
I&#39;ve just come across a funny in pgAdmin 4 version 8.13: when I connect=
 <br>
from my laptop to a server on the same laptop, not all databases are <br>
listed in the tree-view on the left. The server is PostgreSQL 16.6.<br>
<br>
Connecting to the server with psql and doing \l shows me 12 databases, <br>
including template0 and template1. Likewise, &quot;select * from pg_databas=
e&quot; <br>
gives me the same 12 rows. However, the treeview shows only 9... <br>
template* databases are excluded, plus one other of my own.<br>
<br>
Interestingly, when I select from pg_database, the one database of mine <br=
>
which is excluded has an OID of 4; all the others have 5-digit OIDs. I <br>
don&#39;t know why its OID is so low; it&#39;s come forward through a few P=
G <br>
versions over several years, so probably historical baggage.<br>
<br>
All the best,<br>
<br>
Ray.<br>
<br>
-- <br>
Raymond O&#39;Donnell // Galway // Ireland<br>
<a href=3D"mailto:ray@rodonnell.ie" target=3D"_blank">ray@rodonnell.ie</a><=
br>
<br>
<br>
<br>
</blockquote></div><div><br clear=3D"all"></div><div><br></div><span class=
=3D"gmail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_s=
ignature"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"ltr"><div dir=3D"lt=
r"><div dir=3D"ltr"><div><font size=3D"2" color=3D"#000000" face=3D"arial, =
sans-serif">Thanks,</font><div><span style=3D"color:rgb(34,34,34)"><span st=
yle=3D"color:rgb(18,22,70)"><font face=3D"arial, sans-serif">Aditya Toshniw=
al</font></span></span><font size=3D"2" color=3D"#000000" face=3D"verdana, =
sans-serif"><br></font></div><div><span style=3D"color:rgb(18,22,70);font-f=
amily:Arial,sans-serif">pgAdmin Hacker</span><font size=3D"2" color=3D"#000=
000" style=3D"font-family:verdana,sans-serif">=C2=A0| </font><font size=3D"=
2" color=3D"#000000" face=3D"arial, sans-serif">Sr. Staff SDE II</font><fon=
t size=3D"2"><font face=3D"verdana, sans-serif"><font color=3D"#000000">=C2=
=A0|</font><span style=3D"background-color:rgb(255,255,255)"><font color=3D=
"#0c343d"> </font></span></font><a href=3D"https://www.enterprisedb.com/" t=
arget=3D"_blank"><font face=3D"arial, sans-serif" color=3D"#0c343d"><b styl=
e=3D"background-color:rgb(255,255,255)">enterprisedb.com</b></font></a></fo=
nt></div><div><font color=3D"#38761d" size=3D"1"><font face=3D"arial, sans-=
serif">&quot;Don&#39;t Complain about Heat, Plant a TREE&quot;</font></font=
></div></div></div></div></div></div></div></div>

--00000000000085941a062840e41e--