X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.192])
	by svr1.postgresql.org (Postfix) with ESMTP id 4A72DD1C4DC
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 21 Jul 2003 12:52:34 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (svr4.postgresql.org [64.117.224.192]) (amavisd-new,
	port 10024) with ESMTP id 05909-10
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 21 Jul 2003 12:52:29 +0000 (GMT)
Received: from hotmail.com (bay2-f38.bay2.hotmail.com [65.54.247.38])
	by svr1.postgresql.org (Postfix) with ESMTP id 39260D1C511
	for <pgsql-sql@postgresql.org>; Mon, 21 Jul 2003 09:52:28 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Mon, 21 Jul 2003 05:52:31 -0700
Received: from 202.63.107.19 by by2fd.bay2.hotmail.msn.com with HTTP;
	Mon, 21 Jul 2003 12:52:29 GMT
X-Originating-IP: [202.63.107.19]
X-Originating-Email: [m_vijaykumar@hotmail.com]
From: "vijaykumar M" <m_vijaykumar@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: Postgresql Temporary table scripts..
Date: Mon, 21 Jul 2003 12:52:29 +0000
Mime-Version: 1.0
Content-Type: text/html
Message-ID: <BAY2-F38oehHm0ay4Vx0001e144@hotmail.com>
X-OriginalArrivalTime: 21 Jul 2003 12:52:31.0640 (UTC)
	FILETIME=[F2EDF980:01C34F86]
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200307/307
X-Sequence-Number: 14421

<html><div style='background-color:'><P>Hi,</P>
<P>I'm using Postgresqlv7.3.3. </P>
<P>Actually my requirement was to create one temporary table and insert some values on it and finally return the inserted values.</P>
<P>For this simple thing i'm struggling a lot with two errors. one is 'RELATION 'xxxxxxxx' ALREADY EXISTS' -- This is happening when ever i called the function more than ones in the same connection.</P>
<P>To avoid this, i had created a nested function,&nbsp; In inner function i had created the temporary table and inserted some values and finally i called the return values on outter fucntion. this time i get the error as 'RELATION 'xxxxxxxxx' DOES NOT EXIST'.</P>
<P>I hope u all understood my problem.. </P>
<P>if any of u send some sample example to work around this problem will be highly appreciated.</P>
<P>Thanks in advance,</P>
<P>Vijay</P>
<P>&nbsp;</P></div><br clear=all><hr>Watch Hallmark. Enjoy cool movies. <a href="http://g.msn.com/8HMEENIN/2749??PS=">Win hot prizes!</a> </html>