Postgres Pro
Downloads
Home   >   mailing lists

Re: Tempory table is not getting created inside Function in postgres. - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Tempory table is not getting created inside Function in postgres.
Date
Msg-id 8abddd95-02e3-82f1-0003-ec8636d95630@aklaver.com
Whole thread Raw
In response to Tempory table is not getting created inside Function in postgres.  (nikhil raj <nikhilraj474@gmail.com>)
List pgsql-general
Tree view 
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@aklaver.com

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: pg_get_functiondef(), trailing spaces and + sign
Next
From: Adrian Klaver
Date:
Subject: Re: Tempory table is not getting created inside Function in postgres.