Postgresql Temporary table scripts..

From: "vijaykumar M" <m_vijaykumar(at)hotmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Postgresql Temporary table scripts..
Date: 2003-07-21 12:52:29
Message-ID: BAY2-F38oehHm0ay4Vx0001e144@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

<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>

Attachment Content-Type Size
unknown_filename text/html 1017 bytes

Browse pgsql-sql by date

  From Date Subject
Next Message Rod Taylor 2003-07-21 13:09:18 Re: Why their is a limit in Postgresql (psql) Parameters..?
Previous Message jwsacksteder 2003-07-21 12:10:43 query or function