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. I think this is particularly relevant since all databases share the same users. I understand that sometimes the opposite would be desirable, but foreign data wrappers have alleviated that pain. Yours, Laurenz Albe
