Re: Temporary table

["Larry Rosenman" <ler(at)lerctr(dot)org>]

Franklin Haut wrote:
> Hello,
> 
> I´m have some problems with a temporary table, i need create a table,
> insert some values, make a select and at end of transaction the table
> must droped, but after i created a table there not more exist, is
> this normal ? 
> 
> 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;
> 
> 
> 
> In this case, the table cademp doesn´t exist at the first insert, in
> the same transaction.
> 

It is NOT the same transaction.  By default, each STATEMENT is it's own
transaction.

Stick a BEGIN; before the create table, and a commit; after the select.

Larry Rosenman
> 
> 
> 
> Tks,
> 
> Franklin
> 
> 
> ---------------------------(end of
> broadcast)--------------------------- TIP 6: explain analyze is your
> friend 



-- 
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 512-248-2683                 E-Mail: ler(at)lerctr(dot)org
US Mail: 430 Valona Loop, Round Rock, TX 78681-3893