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
Message-ID: <BAY2-F38oehHm0ay4Vx0001e144@hotmail.com> (raw)
<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, 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> </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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: m_vijaykumar@hotmail.com
Subject: Re: Postgresql Temporary table scripts..
In-Reply-To: <BAY2-F38oehHm0ay4Vx0001e144@hotmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox