Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6213: COPY does not work as expected in a plpgsql function - Mailing list pgsql-bugs

From Robert Haas
Subject Re: BUG #6213: COPY does not work as expected in a plpgsql function
Date
Msg-id CA+TgmoaWiexhnopd3q7xTKOgjE7yCz2fEiM_sD36+UWzgD4fbg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #6213: COPY does not work as expected in a plpgsql function  (Ramanujam <innomotive@gmail.com>)
Responses Re: BUG #6213: COPY does not work as expected in a plpgsql function  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
On Mon, Sep 26, 2011 at 12:45 AM, Ramanujam <innomotive@gmail.com> wrote:
> On Mon, Sep 26, 2011 at 9:57 AM, Robert Haas <robertmhaas@gmail.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

pgsql-bugs by date:

Previous
From: Ramanujam
Date:
Subject: Re: BUG #6213: COPY does not work as expected in a plpgsql function
Next
From: Tom Lane
Date:
Subject: Re: BUG #6213: COPY does not work as expected in a plpgsql function