Re: read only transaction, temporary tables - Mailing list pgsql-general

From Tom Lane
Subject Re: read only transaction, temporary tables
Date
Msg-id 19861.1155133597@sss.pgh.pa.us
Whole thread Raw
In response to Re: read only transaction, temporary tables  (Richard Huxton <dev@archonet.com>)
Responses Re: read only transaction, temporary tables
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> Carl R. Brune wrote:
>> I should have added that I want to make further use of the temporary
>> table after the COMMIT -- the rollback approach you propose makes it
>> go away.

> In which case the transaction isn't READONLY.

It does seem a bit inconsistent that we allow you to write into a temp
table during a "READONLY" transaction, but not to create/drop one.
I'm not excited about changing it though, as the tests to see if
the command is allowed would become vastly more complex.

            regards, tom lane

pgsql-general by date:

Previous
From: Kenneth Downs
Date:
Subject: Not so much load balancing as load limits
Next
From: Reece Hart
Date:
Subject: Re: psql/readline clears screen