Postgresql Temporary table scripts.. - Mailing list pgsql-sql

From vijaykumar M
Subject Postgresql Temporary table scripts..
Date
Msg-id BAY2-F38oehHm0ay4Vx0001e144@hotmail.com
Whole thread Raw
List pgsql-sql
<div style="background-color:"><p>Hi,<p>I'm using Postgresqlv7.3.3. <p>Actually my requirement was to create one
temporarytable and insert some values on it and finally return the inserted values.<p>For this simple thing i'm
strugglinga lot with two errors. one is 'RELATION 'xxxxxxxx' ALREADY EXISTS' -- This is happening when ever i called
thefunction more than ones in the same connection.<p>To avoid this, i had created a nested function,  In inner function
ihad created the temporary table and inserted some values and finally i called the return values on outter fucntion.
thistime i get the error as 'RELATION 'xxxxxxxxx' DOES NOT EXIST'.<p>I hope u all understood my problem.. <p>if any of
usend some sample example to work around this problem will be highly appreciated.<p>Thanks in
advance,<p>Vijay<p> </div><brclear="all" /><hr />Watch Hallmark. Enjoy cool movies. <a
href="http://g.msn.com/8HMEENIN/2749??PS=">Winhot prizes!</a> 

pgsql-sql by date:

Previous
From: Rod Taylor
Date:
Subject: Re: Why their is a limit in Postgresql (psql) Parameters..?
Next
From: Bruce Momjian
Date:
Subject: Re: avoid select expens_expr(col) like unneccessary calculations