Re: Tempory table is not getting created inside Function in postgres.
От
Adrian Klaver
Тема
Re: Tempory table is not getting created inside Function in postgres.
Дата
Msg-id
8abddd95-02e3-82f1-0003-ec8636d95630@aklaver.com
Ответ на
Список
Дерево обсуждения
Tempory table is not getting created inside Function in postgres. nikhil raj <nikhilraj474@gmail.com>
Re: Tempory table is not getting created inside Function in postgres. Tom Lane <tgl@sss.pgh.pa.us>
Re: Tempory table is not getting created inside Function in postgres. nikhil raj <nikhilraj474@gmail.com>
Re: Tempory table is not getting created inside Function in postgres. "David G. Johnston" <david.g.johnston@gmail.com>
Re: Tempory table is not getting created inside Function in postgres. nikhil raj <nikhilraj474@gmail.com>
Re: Tempory table is not getting created inside Function in postgres. Adrian Klaver <adrian.klaver@aklaver.com>
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 по дате отправления
От: Adrian Klaver
Дата:
