Re: Problems with temp table and PL

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Problems with temp table and PL
Date: 2007-02-21 21:34:51
Message-ID: 20070221213451.GA15503@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)crankycanuck(dot)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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2007-02-21 21:37:06 Re: Problems with temp table and PL
Previous Message Martin Marques 2007-02-21 21:17:50 Problems with temp table and PL