Tom Lane wrote:
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
Martijn van Oosterhout kleptog@svana.org writes:
Temporary tables still get an entry in pg_class, so for truly readonly
systems they wouldn't work.
The READONLY transaction status is a security mechanism, not a
performance-enhancing mechanism. It makes no pretense of preventing
all disk
Thanks for the information clarifications.
Carl B.
On Tue, 8 Aug 2006, 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.
Carl Brune
On Tue, 8 Aug 2006, John DeSoi wrote:
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. You have two options:
CREATE TEMPORARY TABLE ... AS SELECT ...
BEGIN READONLY;
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
I recently tried to do something like the following
BEGIN READONLY;
...
CREATE TEMPORARY TABLE ABC AS SELECT ...
...
COMMIT;
and it failed because CREATE is not allowed within a read-only
transaction. The select is something long and complicated (pieced
together with php) and I'm just trying to
On Aug 8, 2006, at 1:25 PM, Carl R. Brune wrote:
I recently tried to do something like the following
BEGIN READONLY;
...
CREATE TEMPORARY TABLE ABC AS SELECT ...
...
COMMIT;
and it failed because CREATE is not allowed within a read-only
transaction. The select is something long and
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.
Carl Brune
On Tue, 8 Aug 2006, John DeSoi wrote:
On Aug 8, 2006, at 1:25 PM, Carl R. Brune wrote:
I recently tried to do something like the