From: Stephan Szabo <sszabo@megazone.bigpanda.com>
To: Gerardo Castillo <gcastillo@ice.co.cr>
Cc: pgsql-sql@postgresql.org
Subject: Re: Problem with transaction in functions and tempory tables
Date: Thu, 22 Jul 2004 10:27:00 -0700 (PDT)
Message-ID: <20040722102557.V4811@megazone.bigpanda.com> (raw)
In-Reply-To: <0I19005KZIKF3S@ice.co.cr>
References: <0I19005KZIKF3S@ice.co.cr>
On Thu, 22 Jul 2004, Gerardo Castillo wrote:
> Hello,
>
> I'm using PostgreSQL 7.4
>
> I have a function wich use temporary tables. I read about temporary tables
> and they exists during the session.
> But i have to call this function many times in the same sesion with
> diferents parameters and expecting different results. So, there is a problem
> because the temporary table already exists during the second execution of
> the funcition.
If you're going to use temporary tables in a plpgsql function, you really
need to use the table only through EXECUTE commands so that the plans
don't get saved.
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: sszabo@megazone.bigpanda.com, gcastillo@ice.co.cr
Subject: Re: Problem with transaction in functions and tempory tables
In-Reply-To: <20040722102557.V4811@megazone.bigpanda.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