Re: Temporary table

"Franklin Haut" <franklin.haut@gmail.com> writes:
> How to reproduce :

>     CREATE TEMP TABLE cademp (
>            codemp INTEGER,
>            codfil INTEGER,
>            nomemp varchar(50)
>     ) ON COMMIT DROP;

>     INSERT INTO cademp (codemp, codfil, nomemp) values (1,1,'TESTE');
>     INSERT INTO cademp (codemp, codfil, nomemp) values (1,2,'TESTE1');

>     Select * from cademp;

You need a BEGIN/COMMIT around that, or else rethink using ON COMMIT DROP.
As is, the temp table goes away instantly when the CREATE commits.

            regards, tom lane