On 2/27/23 11:10 AM, nikhil raj wrote:
HI Team,
This is the Function I have created successfully but while executing it
throughs an error temp table doesn't exist.
But the same when I execute it not inside the function from **drop temp
table to end insert select ** it work fine
Please can any one help me why in the function i am not able to create
the temp table. what is alternative
You are running this in pgAdmin4 Query Tool, correct?
Is Autocommit set?
Have you tried this in psql?
--
Adrian Klaver
adrian.kla...@aklaver.com
