public inbox for pgsql-general@postgresql.org
help / color / mirror / Atom feedFrom: Ron Johnson <ronljohnsonjr@gmail.com>
To: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
Date: Fri, 15 May 2026 19:57:45 -0400
Message-ID: <CANzqJaDqtavaNgnwNHHqa-HJcMhBhhKDk75UxnuyPXp4gnHKdA@mail.gmail.com> (raw)
In-Reply-To: <1439462.1778887378@sss.pgh.pa.us>
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>
On Fri, May 15, 2026 at 7:22 PM 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.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
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: pgsql-general@postgresql.org
Cc: ronljohnsonjr@gmail.com
Subject: Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL
In-Reply-To: <CANzqJaDqtavaNgnwNHHqa-HJcMhBhhKDk75UxnuyPXp4gnHKdA@mail.gmail.com>
* 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