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

Hi,

I'm using Postgresqlv7.3.3.

Actually my requirement was to create one temporary table and insert some values on it and finally return the inserted values.

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.

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

I hope u all understood my problem..

if any of u send some sample example to work around this problem will be highly appreciated.

Thanks in advance,

Vijay