Tom, > It's not enough better, because it will still deadlock given a > sufficiently large message-to-send. I don't think you can postpone > the clearing-input action until after all the data is sent. > > regards, tom lane
Please help me understand this better. It appears to me that when the client->backend pipe fills up, pqSendSome() consumes any incoming NOTICE/WARNING messages before waiting, which should prevent deadlock. I'll look at the code again, maybe I missed something. Thx, Alon. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster