Drizzle TeamDT
Drizzle Team•3y ago
MAST

[SOLVED] When running a big bulk insert I get an error, MAX_PARAMETERS_EXCEEDED

I want to run a transaction that runs a large bulk insert but I get this error:
Error: MAX_PARAMETERS_EXCEEDED: Max number of parameters (65534) exceeded
    at toBuffer (/home/mast/workspace/work/mix-opt/dev/node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/cjs/src/connection.js:181:20)
    at Object.execute (/home/mast/workspace/work/mix-opt/dev/node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/cjs/src/connection.js:167:20)
    at Query2.handler2 (/home/mast/workspace/work/mix-opt/dev/node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/cjs/src/index.js:256:15)
    at Query2.handle (/home/mast/workspace/work/mix-opt/dev/node_modules/.pnpm/postgres@3.3.5/node_modules/postgres/cjs/src/query.js:141:65)
Was this page helpful?