X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 21BEFD1BB74 for ; Thu, 22 Apr 2004 18:48:31 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 45778-01 for ; Thu, 22 Apr 2004 18:48:31 -0300 (ADT) Received: from wolverine.lercnetworks.com (sabertooth.lercnetworks.com [140.99.13.90]) by svr1.postgresql.org (Postfix) with ESMTP id 6ACFBD1BA6C for ; Thu, 22 Apr 2004 18:48:28 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) (uid 510) by wolverine.lercnetworks.com with local; Thu, 22 Apr 2004 15:29:32 -0400 From: "Dennis" To: "postgres SQL" Subject: lifetime of temp schema versus compiled image of plpgsql proc Date: Thu, 22 Apr 2004 15:29:32 -0400 Mime-Version: 1.0 Content-Type: text/plain; format=flowed; charset="utf-8" Content-Transfer-Encoding: 7bit Message-ID: X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/239 X-Sequence-Number: 17614 Hi, this is pg 7.4.1 I am opening a connection to postgres starting a transaction executing a plpgsql function that creates temp tables executing a plpgsql function that populates the temp tables querying the temp table closing the transaction then on the same connection, I open a transaction, execute a plpgsql function that populates the temp tables and the function bombs with this error message: ERROR: schema "pg_temp_8" does not exist I am not specifying "on commit" when creating the temp tables. Are temp tables created in a transaction discarded when the transaction ends? I'm not explicitly referencing pg_temp_8 in my stored function. Can someone explain what is going on? Have I given enough information? dennis pg-user at calico dash consulting dot com