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

2011-07-08 Thread mike beeper
I like Darren's proposal. It is elegant. > Date: Fri, 8 Jul 2011 18:38:59 +1200 > From: gavinflo...@archidevsys.co.nz > To: dar...@darrenduncan.net > CC: pg...@j-davis.com; guilla...@lelarge.info; mbee...@hotmail.com; > pgsql-general@postgresql.org; pgsql-hack...@postgresql.org > Subject: Re:

[GENERAL] Creating temp tables inside read only transactions

2011-07-07 Thread mike beeper
I have a function that creates a temp table, populate it with results during intermediate processing, and reads from it at the end. When the transaction is marked as read only, it does not allow creation of temp table, even though there are no permanent writes to the db. Are there any work