RE: Create table in functions

From: "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Andreas Tille" <tillea(at)rki(dot)de>, "PostgreSQL SQL" <pgsql-sql(at)hub(dot)org>
Subject: RE: Create table in functions
Date: 2000-08-24 06:14:02
Message-ID: 000601c00d92$7fa6d480$2801007e@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> -----Original Message-----
> From: Tom Lane
>
> "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)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)

Yes.
We can create a table and insert into it in plpgsql functions if we
call such functions once per session(connection).
Would it be the spec of plpgsql functions in 7.1 ?

Regards.

Hiroshi Inoue

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Anatoly K. Lasareff 2000-08-24 06:39:54 Re: Null function parameters
Previous Message Tom Lane 2000-08-24 05:32:45 Re: Create table in functions