Postgres Pro
Downloads
Home   >   mailing lists

Re: Create table in functions - Mailing list pgsql-sql

From Tom Lane
Subject Re: Create table in functions
Date
Msg-id 25715.967095165@sss.pgh.pa.us
Whole thread Raw
In response to RE: Create table in functions  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
Responses RE: Create table in functions  ("Hiroshi Inoue" <Inoue@tpf.co.jp>)
List pgsql-sql
Tree view 
"Hiroshi Inoue" <Inoue@tpf.co.jp> writes:
> Hmm,Andreas's original function seems to contain other statements.
> If the function contains DML statements for the table Temp_Num_Table,
> it wouldn't work properly. i.e 1st call would work but 2nd call woudn't.

Are you thinking about plpgsql's caching of query plans (and
specifically the table OIDs stored in those plans) or is there another
issue here?

We do need to think about invalidating cached query plans when updates
happen...
        regards, tom lane

pgsql-sql by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: Create table in functions
Next
From: "Hiroshi Inoue"
Date:
Subject: RE: Create table in functions