From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-sql@postgresql.org
Subject: Re: Problems with temp table and PL
Date: Wed, 21 Feb 2007 16:34:51 -0500
Message-ID: <20070221213451.GA15503@phlogiston.dyndns.org> (raw)
In-Reply-To: <Pine.LNX.4.64.0702211814100.18736@bugs.unl.edu.ar>
References: <Pine.LNX.4.64.0702211814100.18736@bugs.unl.edu.ar>
On Wed, Feb 21, 2007 at 06:17:50PM -0300, Martin Marques wrote:
> My problem is that if I execute the same function again (in the same
> session) I get an error when trying to insert data into it (looks like the
> session has an old reference of the table):
You have to use EXECUTE for this. See the docs.
A
--
Andrew Sullivan | ajs@crankycanuck.ca
I remember when computers were frustrating because they *did* exactly what
you told them to. That actually seems sort of quaint now.
--J.D. Baldwin
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: ajs@crankycanuck.ca
Subject: Re: Problems with temp table and PL
In-Reply-To: <20070221213451.GA15503@phlogiston.dyndns.org>
* 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