Re: Problem with temporary tables - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Problem with temporary tables
Date
Msg-id AANLkTimj-sA4C7zs8xhjfpxA5qAdUd3OWyj-crb6tYpN@mail.gmail.com
Whole thread Raw
In response to Re: Problem with temporary tables  (Andrea Lombardoni <andrea@lombardoni.ch>)
List pgsql-general
On Wed, Jun 30, 2010 at 2:41 PM, Andrea Lombardoni <andrea@lombardoni.ch> wrote:
>> You need to use EXECUTE for the INSERT statement as well per error:
>>
>> CONTEXT:  SQL statement "INSERT INTO idmap (oldid, type, newid) VALUES(1,
>>  1, 1)" PL/pgSQL function "test" line 16 at SQL statement
>
> Thanks, this works and solves my problem.
>
> Still, I find this behaviour to be rather quirky.
>

it is fixed on 8.3. So you are out of luck with 8.2 on this one I'm
afraid, gotta go with eXECUTe


--
GJ

pgsql-general by date:

Previous
From: Andrea Lombardoni
Date:
Subject: Re: Problem with temporary tables
Next
From: Pavel Stehule
Date:
Subject: Re: Problem with temporary tables