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

On Fri, May 15, 2026 at 7:22 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Ron Johnson <ronljohnsonjr(at)gmail(dot)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!