From: Dennis <pg-user@calico-consulting.com>
To: postgres SQL <pgsql-sql@postgresql.org>
Subject: lifetime of temp schema versus compiled image of plpgsql proc
Date: Thu, 22 Apr 2004 15:29:32 -0400
Message-ID: <courier.40881D1C.0000705D@wolverine.lercnetworks.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: pg-user@calico-consulting.com
Subject: Re: lifetime of temp schema versus compiled image of plpgsql proc
In-Reply-To: <courier.40881D1C.0000705D@wolverine.lercnetworks.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox