Content-Type: multipart/alternative;
 boundary="------------ZnzZp0gvAaF0q7asCUID544v"
Message-ID: 
 <0102019386dfb4c8-8c5f5150-59fe-4c09-9383-80c4aca64aec-000000@eu-west-1.amazonses.com>
Date: Mon, 2 Dec 2024 10:17:08 +0000
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Some databases not listed in treeview
To: Aditya Toshniwal <aditya.toshniwal@enterprisedb.com>
Cc: Pgadmin-Support <pgadmin-support@postgresql.org>
References: 
 <01020193780372c4-b488dd2b-b1aa-4900-bad8-770dfccd6642-000000@eu-west-1.amazonses.com>
 <CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com>
Content-Language: en-GB
From: Ray O'Donnell <ray@rodonnell.ie>
In-Reply-To: 
 <CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com>
Feedback-ID: 
 ::1.eu-west-1.Bw1eu/7Uepg3xcsiFBL71JJRCh2A2yTFrgBhhiulXmU=:AmazonSES
Archived-At: 
 <https://www.postgresql.org/message-id/0102019386dfb4c8-8c5f5150-59fe-4c09-9383-80c4aca64aec-000000%40eu-west-1.amazonses.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------ZnzZp0gvAaF0q7asCUID544v
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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

--------------ZnzZp0gvAaF0q7asCUID544v
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html>
<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">Helo Aditya,<br>
      <br>
      Thanks for responding. I've no idea how that happened either!
      Anyway, I'm glad to know what the issue is - thanks for
      clarifying.<br>
      <br>
      Ray.<br>
      <br>
      <br>
      On 02/12/2024 03:10, Aditya Toshniwal wrote:<br>
    </div>
    <blockquote type="cite"
cite="mid:CAM9w-_miggo2YXt_eZ7YE1j55NObe-aUCq2yD2C0drmBzbgOWQ@mail.gmail.com">
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <div dir="ltr">
        <div class="gmail_default"
          style="font-family:verdana,sans-serif">Hi Ray,</div>
        <div class="gmail_default"
          style="font-family:verdana,sans-serif"><br>
        </div>
        <div class="gmail_default"
          style="font-family:verdana,sans-serif">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.</div>
      </div>
      <br>
      <div class="gmail_quote">
        <div dir="ltr" class="gmail_attr">On Fri, Nov 29, 2024 at
          6:32 PM Ray O'Donnell &lt;<a href="mailto:ray@rodonnell.ie"
            moz-do-not-send="true" class="moz-txt-link-freetext">ray@rodonnell.ie</a>&gt;
          wrote:<br>
        </div>
        <blockquote class="gmail_quote"
style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Hi
          all,<br>
          <br>
          I'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, "select * from
          pg_database" <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't know why its OID is so low; it's come forward through a
          few PG <br>
          versions over several years, so probably historical baggage.<br>
          <br>
          All the best,<br>
          <br>
          Ray.<br>
          <br>
          -- <br>
          Raymond O'Donnell // Galway // Ireland<br>
          <a href="mailto:ray@rodonnell.ie" target="_blank"
            moz-do-not-send="true" class="moz-txt-link-freetext">ray@rodonnell.ie</a><br>
          <br>
          <br>
          <br>
        </blockquote>
      </div>
      <div><br clear="all">
      </div>
      <div><br>
      </div>
      <span class="gmail_signature_prefix">-- </span><br>
      <div dir="ltr" class="gmail_signature">
        <div dir="ltr">
          <div dir="ltr">
            <div dir="ltr">
              <div dir="ltr">
                <div dir="ltr">
                  <div><font size="2" color="#000000"
                      face="arial, sans-serif">Thanks,</font>
                    <div><span style="color:rgb(34,34,34)"><span
                          style="color:rgb(18,22,70)"><font
                            face="arial, sans-serif">Aditya Toshniwal</font></span></span><font
                        size="2" color="#000000"
                        face="verdana, sans-serif"><br>
                      </font></div>
                    <div><span
style="color:rgb(18,22,70);font-family:Arial,sans-serif">pgAdmin Hacker</span><font
                        size="2" color="#000000"
                        style="font-family:verdana,sans-serif"> | </font><font
                        size="2" color="#000000"
                        face="arial, sans-serif">Sr. Staff SDE II</font><font
                        size="2"><font face="verdana, sans-serif"><font
                            color="#000000"> |</font><span
                            style="background-color:rgb(255,255,255)"><font
                              color="#0c343d"> </font></span></font><a
                          href="https://www.enterprisedb.com/"
                          target="_blank" moz-do-not-send="true"><font
                            face="arial, sans-serif" color="#0c343d"><b
                              style="background-color:rgb(255,255,255)">enterprisedb.com</b></font></a></font></div>
                    <div><font color="#38761d" size="1"><font
                          face="arial, sans-serif">"Don't Complain about
                          Heat, Plant a TREE"</font></font></div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
      </div>
    </blockquote>
    <br>
    <br>
    <pre class="moz-signature" cols="72">-- 
Raymond O'Donnell // Galway // Ireland
<a class="moz-txt-link-abbreviated" href="mailto:ray@rodonnell.ie">ray@rodonnell.ie</a></pre>
  </body>
</html>

--------------ZnzZp0gvAaF0q7asCUID544v--