Re: Tempory table is not getting created inside Function in postgres.

[Adrian Klaver <adrian.klaver@xxxxxxxxxxx>]

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.klaver@xxxxxxxxxxx