On 09/07/2022 00:09, Andrey Lepikhov wrote:
On 8/7/2022 05:12, Ian Barwick wrote:
     ERROR:  bind message supplies 0 parameters, but prepared statement 
"pgsql_fdw_prep_178" requires 6
     CONTEXT:  remote SQL command: INSERT INTO public.foo_part_1(t, v1, v2, v3, 
v4, v5) VALUES ($1, $2, $3, $4, $5, $6)
     COPY foo, line 88160
Thanks, I got it. MultiInsertBuffer are created on the first non-zero flush of 
tuples into the partition and isn't deleted from the buffers list until the end 
of COPY. And on a subsequent flush in the case of empty buffer we catch the 
error.
Your fix is correct, but I want to propose slightly different change (see in 
attachment).

LGTM.

Regards

Ian Barwick

--
https://www.enterprisedb.com/


Reply via email to