Re: Problems with temp table and PL - Mailing list pgsql-sql

From Andrew Sullivan
Subject Re: Problems with temp table and PL
Date
Msg-id 20070221213451.GA15503@phlogiston.dyndns.org
Whole thread Raw
In response to Problems with temp table and PL  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-sql
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


pgsql-sql by date:

Previous
From: Martin Marques
Date:
Subject: Problems with temp table and PL
Next
From: "A. Kretschmer"
Date:
Subject: Re: Problems with temp table and PL