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