Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group