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

Hi Tom,

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.

On Tue, 28 Feb, 2023, 1:34 am Tom Lane, <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> nikhil raj <nikhilraj474(at)gmail(dot)com> writes:
> > This is the Function I have created successfully but while executing it
> > throughs an error temp table doesn't exist.
>
> You won't be able to do it like that in a SQL-language function, because
> the whole function body is parsed and parse-analyzed in one go. So the
> later query referencing ROSTER_TABLE fails because it's parsed before
> the CREATE TABLE executes. (Improving that has been on the to-do list
> for a couple of decades, so don't hold your breath...) I suggest putting
> the whole thing, not just part of it, into plpgsql.
>
> regards, tom lane
>