Feature Requests item #1420335, was opened at 2006-01-31 10:42
Message generated for change (Comment added) made by nielsnes
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1420335&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL - general
Group: None
Status: Open
Priority: 5
Private: No
Submitted By: leemarks (leemarks)
Assigned to: Nobody/Anonymous (nobody)
Summary: Connection-scoped temporary tables
Initial Comment:
Currently MonetDB temporary tables can only live within
a single transaction. It would be useful if this could
be extended to also support connection-based life spans.
One approach is the way it's done in Postgres where the
desired behaviour can be selected with an 'on commit'
clause on the create table statement.
Specifically :-
CREATE TEMP TABLE tbl ( ... ) ON COMMIT
{ PRESERVE ROWS | DELETE ROWS | DROP }
where
PRESERVE ROWS gives a connection based life span
DELETE ROWS truncates the table at the end of each trans
DROP drops the table (the current monetdb behaviour)
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2007-11-10 21:57
Message:
Logged In: YES
user_id=43556
Originator: NO
this feature has been implemented some time ago.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482471&aid=1420335&group_id=56967
-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
