On Fri, 2021-06-11 at 16:57 -0400, Robert Haas wrote: > My impression was that CopyBoth can be initiated either way,
The docs say: "In either physical replication or logical replication walsender mode, only the simple query protocol can be used." Is there some way to initiate CopyBoth outside of walsender? > but if > you use the extended query protocol, then the result is a hopeless > mess, because the protocol is badly designed: > > https://www.postgresql.org/message-id/ca+tgmoa4ea+cpxaigqmebp9xisvd3ze9dbvnbzevx9ucmiw...@mail.gmail.com It seems like you're saying that CopyIn and CopyBoth are both equally broken in extended query mode. Is that right? > But I think you're correct in saying that the discard-until-Sync > behavior only happens if the extended query protocol is used, so I > agree that the current text is wrong. Should we just document how CopyBoth works with the simple query protocol, or should we make it match the CopyIn docs? Regards, Jeff Davis