Re: libpq: COPY FROM STDIN BINARY of arrays

2023-03-31 Thread Dominique Devienne
On Thu, Mar 30, 2023 at 6:00 PM Tom Lane wrote: > Dominique Devienne writes: > > Does the wire-format of arrays differ between binary-binds and > binary-copy? > > No. > An update on this, I think I figure it out, by comparing with COPY TO STDOUT WITH (FORMAT BINARY). I was missing the byte-coun

Re: libpq: COPY FROM STDIN BINARY of arrays

2023-03-30 Thread Tom Lane
Dominique Devienne writes: > Does the wire-format of arrays differ between binary-binds and binary-copy? No. > Any pointers to what I could look at, to resolve this? doc? code? example? array_send and array_recv might help you. Keep in mind that maybe the problem is with array element(s) not t

libpq: COPY FROM STDIN BINARY of arrays

2023-03-30 Thread Dominique Devienne
Hi, I already use arrays fine (e.g. text[]) in BINARY mode binds (with prepared statement or not). I already use COPY FROM STDIN BINARY fine, with scalar values. But for the 1st time, I'm combining COPY with arrays, and it is NOT fine yet :( #08P01: ERROR: insufficient data left in message CONT