Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Temporary table
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: "Franklin Haut" <franklin(dot)haut(at)gmail(dot)com>
- Cc: pgsql-performance(at)postgresql(dot)org
- Subject: Re: Temporary table
- Date: Fri, 23 Jun 2006 18:04:28 -0400
"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
- References:
- Temporary table
- From: Franklin Haut
- Temporary table
- Prev by Date: Temporary table
- Next by Date: Re: Temporary table
- Previous by thread: Temporary table
- Next by thread: Re: Temporary table
- Indexes: