MIME-Version: 1.0
References: 
 <CAHWFTRjCy3U30whQJBw8z5_8boq=V9MzbtHMh6HZVP3o-OaGxg@mail.gmail.com>
 <F93CFB3A-0269-4261-804C-0CBAB5DF089D@elevarq.com>
 <CANzqJaBVAykTGq8j-gijJS-L0bK7duyO-k2xKgr8ZmO9mqxXMw@mail.gmail.com>
 <1439462.1778887378@sss.pgh.pa.us>
In-Reply-To: <1439462.1778887378@sss.pgh.pa.us>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 15 May 2026 19:57:45 -0400
Message-ID: 
 <CANzqJaDqtavaNgnwNHHqa-HJcMhBhhKDk75UxnuyPXp4gnHKdA@mail.gmail.com>
Subject: Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000004c758d0651e3fbf8"
Archived-At: 
 <https://www.postgresql.org/message-id/CANzqJaDqtavaNgnwNHHqa-HJcMhBhhKDk75UxnuyPXp4gnHKdA%40mail.gmail.com>
Precedence: bulk

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

On Fri, May 15, 2026 at 7:22=E2=80=AFPM Tom Lane <tgl@sss.pgh.pa.us> wrote:

> Ron Johnson <ronljohnsonjr@gmail.com> writes:
> > Why doesn't the shared OID space make cross-database queries possible?
>
> OIDs are not guaranteed unique across databases.


Ah.


> But totally independently of implementation considerations, it's not
> apparent to me that this would be a good idea.  As Frank mentioned,
> Postgres has always treated databases as isolation boundaries.
> Changing that would probably break a lot of peoples' installation
> designs.
>

Even now, roles need privilege to access databases.

--=20
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

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

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, May 15, 2026 at 7:22=E2=80=AFPM T=
om Lane &lt;<a href=3D"mailto:tgl@sss.pgh.pa.us">tgl@sss.pgh.pa.us</a>&gt; =
wrote:</div><div class=3D"gmail_quote gmail_quote_container"><blockquote cl=
ass=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid=
 rgb(204,204,204);padding-left:1ex">Ron Johnson &lt;<a href=3D"mailto:ronlj=
ohnsonjr@gmail.com" target=3D"_blank">ronljohnsonjr@gmail.com</a>&gt; write=
s:<br>
&gt; Why doesn&#39;t the shared OID space make cross-database queries possi=
ble?<br>
<br>
OIDs are not guaranteed unique across databases.</blockquote><div><br></div=
><div>Ah.</div><div>=C2=A0</div><blockquote class=3D"gmail_quote" style=3D"=
margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-lef=
t:1ex">But totally independently of implementation considerations, it&#39;s=
 not<br>
apparent to me that this would be a good idea.=C2=A0 As Frank mentioned,<br=
>
Postgres has always treated databases as isolation boundaries.<br>
Changing that would probably break a lot of peoples&#39; installation<br>
designs.<br></blockquote><div></div></div><div><br></div><div>Even now, rol=
es need privilege to access databases.</div><div><br></div><span class=3D"g=
mail_signature_prefix">-- </span><br><div dir=3D"ltr" class=3D"gmail_signat=
ure"><div dir=3D"ltr">Death to &lt;Redacted&gt;, and butter sauce.<div>Don&=
#39;t boil me, I&#39;m still alive.<br><div><div>&lt;Redacted&gt; lobster!<=
/div></div></div></div></div></div>

--0000000000004c758d0651e3fbf8--