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!