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 workarounds? The following block errors out. SET TRANSACTION ISOLATION LEVEL READ COMMITTED READ ONLY; create temp table test(test int);
- [GENERAL] Creating temp tables inside read only transact... mike beeper
- Re: [GENERAL] Creating temp tables inside read only... Guillaume Lelarge
- Re: [GENERAL] Creating temp tables inside read ... Darren Duncan
- Re: [HACKERS] [GENERAL] Creating temp table... Jeff Davis
- Re: [HACKERS] [GENERAL] Creating temp t... Darren Duncan
- Re: [HACKERS] [GENERAL] Creating t... Jeff Davis
- Re: [HACKERS] [GENERAL] Creati... Darren Duncan
- Re: [HACKERS] [GENERAL] Cr... Jeff Davis
- Re: [HACKERS] [GENERAL] Creating t... Gavin Flower
- Re: [HACKERS] [GENERAL] Creati... mike beeper
- Re: [HACKERS] [GENERAL] Creating t... Robert Haas