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