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

From Tom Lane
Subject Re: BUG #6213: COPY does not work as expected in a plpgsql function
Date
Msg-id 5875.1317047583@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #6213: COPY does not work as expected in a plpgsql function  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Robert Haas <robertmhaas@gmail.com> writes:
> It would actually be nice if worked even without that, but I'm not
> sure what would be involved in making that happen.

I've been too busy to look at this in detail, but I imagine the issue is
failure to pass parameters down from the ProcessUtility call to COPY
into the parsing/execution of the sub-SELECT.  It might be relatively
straightforward to fix, or then again it might not.  The parsing end of
it could quite likely be harder than the execution end.  We've
surmounted similar issues in places like EXPLAIN, though.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: BUG #6213: COPY does not work as expected in a plpgsql function
Next
From: "Daniel Cristian Cruz"
Date:
Subject: BUG #6225: Child table with a missing parent key which no exists in a complex trigger/cascade schema