Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 98D11475FCF for ; Mon, 29 Apr 2002 12:18:21 -0400 (EDT) Received: from jbarilla.student.princeton.edu (jbarilla.student.Princeton.EDU [140.180.137.120]) by postgresql.org (Postfix) with ESMTP id 0FF98475D22 for ; Mon, 29 Apr 2002 12:07:12 -0400 (EDT) Received: (from jbarilla@localhost) by jbarilla.student.princeton.edu (8.11.6/8.11.6) id g3TG7E501907; Mon, 29 Apr 2002 12:07:14 -0400 To: Tom Lane Cc: pgsql-sql Subject: Re: Temporary table weirdness References: <23409.1020089557@sss.pgh.pa.us> From: Joseph Barillari X-Public-Key: finger -l jbarilla@phoenix.princeton.edu X-Public-Key-Fingerprint: 99C7 4F49 AF41 AD0F A4FC 529C 215E 1BD2 F6A1 FA37 X-URL: http://www.princeton.edu/~jbarilla Date: Mon, 29 Apr 2002 12:07:14 -0400 In-Reply-To: <23409.1020089557@sss.pgh.pa.us> (Tom Lane's message of "Mon, 29 Apr 2002 10:12:37 -0400") Message-ID: Lines: 17 User-Agent: Gnus/5.090006 (Oort Gnus v0.06) Emacs/21.2.50 (i686-pc-linux-gnu) MIME-Version: 1.0 Content-Type: multipart/signed; boundary="=-=-="; micalg=pgp-sha1; protocol="application/pgp-signature" X-Archive-Number: 200204/360 X-Sequence-Number: 7624 --=-=-= Content-Transfer-Encoding: quoted-printable >>>>> "TL" =3D=3D Tom Lane writes: TL> In the meantime, you need to use EXECUTE to defeat the plan TL> caching for every plpgsql query that touches the temp table. TL> Another answer is to arrange to create the temp table only TL> once per session, but that's harder. That's actually what I did -- the client programs in this application have to call a function to create the various temporary tables at the start of their database sessions. It's a bit of a kludge, but there are only a few client applications which talk to this database. Regards, Joe Barillari --=-=-= Content-Type: application/pgp-signature -----BEGIN PGP MESSAGE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: Processed by Mailcrypt 3.5.6 and Gnu Privacy Guard iD8DBQE8zW+yIV4b0vah+jcRAjdFAJkB4skrw9LnGzYVMfODm3th5SbRRgCeO56i rGslW4N6oQQCAXXZiPEY3Wk= =PJzl -----END PGP MESSAGE----- --=-=-=--