Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

2011-07-10 Thread Christopher Browne
On Mon, Jul 11, 2011 at 12:01 AM, Michael Nolan wrote: > > > On Fri, Jul 8, 2011 at 10:27 PM, Robert Haas 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

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

2011-07-10 Thread John R Pierce
On 07/10/11 9:01 PM, Michael Nolan wrote: 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. For which w

Re: [HACKERS] [GENERAL] Creating temp tables inside read only transactions

2011-07-10 Thread Michael Nolan
On Fri, Jul 8, 2011 at 10:27 PM, Robert Haas 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