X-Original-To: pgsql-performance-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id 742579FB0D1
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 23 Jun 2006 18:52:26 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 20439-02 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 23 Jun 2006 18:52:19 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from wx-out-0102.google.com (wx-out-0102.google.com [66.249.82.203])
	by postgresql.org (Postfix) with ESMTP id BA3509FA60B
	for <pgsql-performance@postgresql.org>;
	Fri, 23 Jun 2006 18:52:20 -0300 (ADT)
Received: by wx-out-0102.google.com with SMTP id i31so564396wxd
	for <pgsql-performance@postgresql.org>;
	Fri, 23 Jun 2006 14:52:18 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:from:to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:x-mimeole;
	b=fJjBY9uo6cPvvb2JRRxWk5j0m8ZNBZuTZ9pEQLRRqsvMv4+Un2oL3tiam9je7OPp3dz0Ap5obtigWJVrGV5FU5Moe3y3meIZaADUj7g8PlLaZWJ8vYRKPpPjW4u5Ho47YuJLapLdNiNIV+H1O8JMViMG7MovBjnrOchJ+M+JMxw=
Received: by 10.70.44.11 with SMTP id r11mr5363542wxr;
	Fri, 23 Jun 2006 14:52:18 -0700 (PDT)
Received: from franklin ( [201.2.219.138])
	by mx.gmail.com with ESMTP id h34sm3028600wxd.2006.06.23.14.52.15;
	Fri, 23 Jun 2006 14:52:17 -0700 (PDT)
From: "Franklin Haut" <franklin.haut@gmail.com>
To: <pgsql-performance@postgresql.org>
Subject: Temporary table
Date: Fri, 23 Jun 2006 18:58:22 -0300
Message-ID: <000001c69710$264fe940$8adb02c9@franklin>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
X-Mailer: Microsoft Office Outlook 11
Thread-Index: AcaWJ6kB91I7F+1CQfamxokjjD/fiQAycwtQAAeoJXA=
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.504
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200606/466
X-Sequence-Number: 19823


Hello,

I=B4m 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');
=09
	Select * from cademp;



In this case, the table cademp doesn=B4t exist at the first insert, in =
the
same transaction.




Tks,

Franklin