Re: [HACKERS] Creating temp tables inside read only transactions - Mailing list pgsql-general

From Michael Nolan
Subject Re: [HACKERS] Creating temp tables inside read only transactions
Date
Msg-id CAOzAquJiDtVcybmkFZ1GhwABdU3r8pWWKmeztEs58Di33jwnjQ@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Creating temp tables inside read only transactions  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: [HACKERS] Creating temp tables inside read only transactions
Re: [HACKERS] Creating temp tables inside read only transactions
List pgsql-general


On Fri, Jul 8, 2011 at 10:27 PM, Robert Haas <robertmhaas@gmail.com> wrote:

But if that's what you want, just don't put your data in different
databases in the first place.  That's what schemas are for.

Sadly, DBAs don't always have the ability to put all their data in one database, even if that is what schemas are for.

The ability to do cross-database (most likely cross-server as well) queries would address a lot of real-world problems.
-
Mike Nolan
nolan@tssi.com

pgsql-general by date:

Previous
From: Darren Duncan
Date:
Subject: Re: [HACKERS] Creating temp tables inside read only transactions
Next
From: John R Pierce
Date:
Subject: Re: [HACKERS] Creating temp tables inside read only transactions