Thread: Postgresql Temporary table scripts..

Postgresql Temporary table scripts..

From
"vijaykumar M"
Date:
<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>