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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Tempory table is not getting created inside Function in postgres.
Дата
Msg-id CAKFQuwabgdjHp6-NOv-mawSbshwy_5pjeFAFV5z18yjq-siAWw@mail.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.  (nikhil raj <nikhilraj474@gmail.com>)
Список pgsql-general
Дерево обсуждения
On Mon, Feb 27, 2023 at 1:17 PM nikhil raj <nikhilraj474@gmail.com> wrote:

The same query  is executed outside the function its working properly  means just the qurey from drop temp table to insert but when i keep the query inside a function its through me the error an after temp ra how creation only i am using the select statment still its not exectuing the create  statment or not storing the temp table.


What Tom said is that in the following change 'sql' to plpgsql and move on.  Your function is not capable of being executed in an SQL language function.

CREATE OR REPLACE FUNCTION api."post_publish_Roster"(
    )
        RETURNS void
        LANGUAGE 'sql'
        COST 100
        VOLATILE PARALLEL UNSAFE
    AS $BODY$

David J.

В списке pgsql-general по дате отправления:

Предыдущее
От: nikhil raj
Дата:
Сообщение: Re: Tempory table is not getting created inside Function in postgres.
Следующее
От: Kirk Wolak
Дата:
Сообщение: Re: pg_get_functiondef(), trailing spaces and + sign