Q017error

Slice with batch or copyfrom

A kind: slice parameter is used with the batch or copyfrom command.

db/queries/example.sql:1:1: error[Q017]: query "AddBooks": a kind: slice parameter cannot be used with the copyfrom command, which sends one row of parameters per item and cannot expand a slice
Printed by sgl from a small PostgreSQL reproduction project.

When it is reported

batch and copyfrom send one row at a time, so they cannot expand a slice into an IN list.

How to fix it

Use a plain parameter, or a different command.

See it in an example

In your terminal

$ sgl explain Q017

Look for SliceBatchCopyFrom in Seagull's source to see where it is reported.