Temporary table

From: "Franklin Haut" <franklin(dot)haut(at)gmail(dot)com>
To: <pgsql-performance(at)postgresql(dot)org>
Subject: Temporary table
Date: 2006-06-23 21:58:22
Message-ID: 000001c69710$264fe940$8adb02c9@franklin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance


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.

Tks,

Franklin

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2006-06-23 22:04:28 Re: Temporary table
Previous Message Daniel Xavier de Sousa 2006-06-23 18:32:35 Buffers to Nest Loop Join