Re: BUG #6213: COPY does not work as expected in a plpgsql function

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Ramanujam <innomotive(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6213: COPY does not work as expected in a plpgsql function
Date: 2011-09-26 13:40:46
Message-ID: CA+TgmoaWiexhnopd3q7xTKOgjE7yCz2fEiM_sD36+UWzgD4fbg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Sep 26, 2011 at 12:45 AM, Ramanujam <innomotive(at)gmail(dot)com> wrote:
> On Mon, Sep 26, 2011 at 9:57 AM, Robert Haas <robertmhaas(at)gmail(dot)com> wrote:
>> Does it work if you use EXECUTE?
>
> Apologies to have not included the list when I replied to Pavel.
> Re-writing it as a dynamic sql stmt indeed works. Sorry for the noise.

Ah, OK. No problem.

It would actually be nice if worked even without that, but I'm not
sure what would be involved in making that happen.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Dean Heller 2011-09-26 14:02:33 BUG #6224: Installation Error of dotconnect for postgre SQL Professional
Previous Message Peter Eisentraut 2011-09-26 10:52:23 Re: [v9.2] make_greater_string() does not return a string in some cases