"Franklin Haut" <franklin(dot)haut(at)gmail(dot)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