Received: from datasoft.com (maniac.datasoft.com [63.228.155.187]) by postgresql.org (8.11.3/8.11.1) with SMTP id f5RKpEa87653 for ; Wed, 27 Jun 2001 16:51:14 -0400 (EDT) (envelope-from kristis.makris@datasoft.com) Message-Id: <200106272051.f5RKpEa87653@postgresql.org> Received: (qmail 10176 invoked from network); 27 Jun 2001 20:51:07 -0000 Received: from dsco-user.datasoft.com (HELO leonidas.corp.datasoft.com) (63.228.155.190) by maniac.datasoft.com with SMTP; 27 Jun 2001 20:51:07 -0000 Subject: Re: Using the extract() function in plpgsql From: Kristis Makris To: Tom Lane Cc: Richard Huxton , pgsql-sql@postgresql.org In-Reply-To: <13712.993672268@sss.pgh.pa.us> References: <200106202233.f5KMXSa91452@postgresql.org> <003701c0fa5e$722570a0$1001a8c0@archonet.com> <200106261958.f5QJwsa45412@postgresql.org> <3B398892.D0001CDE@archonet.com> <200106271556.f5RFu4a53609@postgresql.org> <3B3A265E.E13F3944@archonet.com> <13712.993672268@sss.pgh.pa.us> Content-Type: text/plain X-Mailer: Evolution (0.9/+cvs.2001.03.14.20.47 - Preview Release) Date: 27 Jun 2001 13:51:07 -0700 Mime-Version: 1.0 X-Archive-Number: 200106/440 X-Sequence-Number: 3737 On 27 Jun 2001 16:04:28 -0400, Tom Lane wrote: > Richard Huxton writes: > > 2. bad oid reference - even if we did recreate the table, the reference > > to it is compiled in after the first run. Don't see a way around this one. > > You could work around that by making all the queries referencing the > temp table be built up as strings and EXECUTE'd, rather than just > writing them in-line in the plpgsql code. Pretty grotty but it might > serve for now. Eventually plpgsql needs to have a way to discard > query plans that have been obsoleted by DDL changes. > > regards, tom lane Good point, but this approach might not be able to handle all the queries required to be executed. In particular the EXECUTE of SELECT ... INTO is not implemented yet, as of Postgres 7.1.2. Any thoughts on when this feature will be implemented? 7.1.x ? 7.x ?