Re: Suggestion for Easier Cross-Database Query Handling in PostgreSQL

Ron Johnson <ronljohnsonjr@gmail.com>

From: Ron Johnson <ronljohnsonjr@gmail.com>
To: "pgsql-general@postgresql.org" <pgsql-general@postgresql.org>
Date: 2026-05-15T23:57:45Z
Lists: pgsql-general
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!