In article <dklr9g$781$2(at)news(dot)hub(dot)org>, Andrus Moor <eetasoft(at)online(dot)ee> wrote:
>I need to create temporary table with data which is dropped at end of
>transaction.
>
>CREATE TABLE t1 ( c1 INTEGER ) ;
>INSERT INTO t1 VALUES (1);
>CREATE TEMP TABLE t2 AS SELECT * FROM t1 ON COMMIT DROP;
>
>Causes ERROR: syntax error at or near "ON" at character 104
>
>How to implement this ?
You can't just explicitly drop the table just before the commit?
--
http://yosemitenews.info/