Received: from sd.tpf.co.jp (IDENT:qmailr@sd.tpf.co.jp [210.161.239.34]) by hub.org (8.10.1/8.10.1) with SMTP id e7O6An530097 for ; Thu, 24 Aug 2000 02:10:49 -0400 (EDT) Received: (qmail 13640 invoked from network); 24 Aug 2000 06:10:44 -0000 Received: from unknown (HELO cadzone) (126.0.1.40) by sd2.10.0.100.in-addr.arpa with SMTP; 24 Aug 2000 06:10:44 -0000 From: "Hiroshi Inoue" To: "Tom Lane" Cc: "Andreas Tille" , "PostgreSQL SQL" Subject: RE: Create table in functions Date: Thu, 24 Aug 2000 15:14:02 +0900 Message-ID: <000601c00d92$7fa6d480$2801007e@tpf.co.jp> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 In-Reply-To: <25715.967095165@sss.pgh.pa.us> X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 Importance: Normal X-Archive-Number: 200008/260 > -----Original Message----- > From: Tom Lane > > "Hiroshi Inoue" 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