On Thu, 2020-06-04 at 16:41 +1200, Thomas Munro wrote: > There's no doubt it's useful, and it's also part of the SQL spec, > which says you can do catalog.schema.table. I would guess that we > might get that as a byproduct of any project to make PostgreSQL > multithreaded. That mountain moving operation will require us to get > rid of all the global state that currently ties a whole process to one > session and one database, and replace it with heap objects with names > like Session and Database that can be passed around between worker > threads.
I am -1 on cross-database queries.
I think it is a desirable feature to have databases isolated from each other, so you don't have to worry about a permission you forgot that allows somebody to access a different database.
Perhaps make it a new right that can be granted and it is disabled by default.
Superusers could have it by default.
ALTER USER foo WITH CROSSDB | NOCROSSDB
Obviously there is much more to flesh out than this.