Simon Riggs wrote: > On Mon, 2008-01-14 at 18:46 +0000, Tom Lane wrote: > > Log Message: > > ----------- > > Fix an ancient oversight in libpq's handling of V3-protocol COPY OUT mode: > > we need to be able to swallow NOTICE messages, and potentially also > > ParameterStatus messages (although the latter would be a bit weird), > > without exiting COPY OUT state. Fix it, and adjust the protocol > > documentation > > to emphasize the need for this. Per off-list report from Alexander Galler. > > My reading of this is that previously a PQgetCopyData() operation would > fail mysteriously because of > > i) a reload of postgresql.conf, following the setting of any of the > following parameters client_encoding, DateStyle, TimeZone, and > standard_conforming_strings.
Hmm, aren't ParameterStatus messages sent just before Ready For Query? > ii) any previous LISTEN command on the session running the COPY I don't think LISTEN is involved. It's NOTICE that's a problem, not NOTIFY. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
