On Tue, 2008-01-15 at 16:37 -0500, Tom Lane wrote: > Neither of those events could trigger it, because neither would be > processed midstream during a COPY (in the current code, anyway).
OK, thanks. > As best I can tell: > > * NOTICE messages are a risk, especially if you have a more-verbose- > than-normal client_min_messages setting. > > * ParameterStatus could be a risk if a function executed during COPY > tried to change one of the above-mentioned parameters. Since COPY OUT > doesn't fire triggers, I think user-defined datatype output functions > would be the only possible candidates for that. Understood > * LISTEN/NOTIFY isn't a risk because the backend only sends NOTIFY at > transaction end, period. OK, just seen the comment section above the case statement. -- Simon Riggs 2ndQuadrant http://www.2ndQuadrant.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
