Andrei Matei <andreimatei1@gmail.com> writes:
> I've got a question about the wire protocol; the relevant text in the docs
> seems a bit ambiguous to me. If the processing of a Sync message fails
> (e.g. because the commit of the current transaction fails), is the backend
> allowed to respond with an ErrorResponse, in addition to the ReadyForQuery
> message? Or, does the backend swallow the error, and return only the
> ReadyForQuery (I hope not).
Uh ... I don't think Sync itself can fail. Any ErrorResponse you see
there is really from failure of some prior command. The Sync is really
delimiting how much stuff you'd like to skip in case of a failure.
Basically this is to allow pipelining of commands, with the ability to
discard later commands if an earlier one fails.
But in any case, no, Sync would not suppress an error message if
one is needed.
regards, tom lane