Hi guys, currently I’m working on a “database chat”, I’m downloading a CSV file from Google Drive and then insert the data into postgres database, this is working fine however, when I increase the number of data I got an error related to exceed the number of variables
Error message:
Problem in node ‘perform insertion1‘
Variable $100001 exceeds supported maximum of $100000
My workflow to insert the data, this error message is returned by the last node
The output returned by the last node:
Variable $100001 exceeds supported maximum of $100000
Failed query: INSERT INTO ai_table_ventas_contado (“idVenta”, “monto”, “pago”, “fecha”, “idCliente”, “idUsuario”) VALUES ($1, $2, $3, $4, $5, $6), ($7, $8, $9, $10, $11, $12), ($13, $14, $15, $16, $17, $18), ($19, $20, $21, $22, $23, $24), ($25, $26, $27, $28, $29, $30), ($31, $32, $33, $34, $35, $36), ($37, $38, $39, $40, $41, $42), ($43, $44, $45, $46, $47, $48), ($49, $50, $51, $52, $53, $54), ($55, $56, $57, $58, $59, $60), ($61, $62, $63, $64, $65, $66), ($67, $68, $69, $70, $71, $72), ($73, $74, $75, $76, $77, $78), ($79, $80, $81, $82, $83, $84), ($85, $86, $87, $88, $89, $90), ($91, $92, $93, $94, $95, $96), ($97, $98, $99, $100, $101, $102), ($103, $104, $105, $106, $107, $108), ($109, $110, $111, $112, $113, $114), …
Anyone else facing the same issue?
How can I increase the number of supported variables?
Information on your n8n setup
- **n8n version: 1.82.3 **
- **Database (default: SQLite): Postgres **
- **n8n EXECUTIONS_PROCESS setting (default: own, main): **
- **Running n8n via (Docker, npm, n8n cloud, desktop app): Docker **
- **Operating system: Windows 10 **
Thanks!