sqlc icon indicating copy to clipboard operation
sqlc copied to clipboard

postgres 17: support ON_ERROR with `:copyfrom`

Open tburgin opened this issue 2 months ago • 0 comments

What do you want to change?

Hello, I am wondering if :copyfrom supports ON_ERROR? With sqlc v1.30.0 I receive syntax error at or near "ON_ERROR" for a statment like:

-- name: InsertKeyValues :copyfrom
INSERT INTO kvs (
  id, key, value
) VALUES (
  @id, @key, @value
) ON_ERROR ignore;

What database engines need to be changed?

PostgreSQL

What programming language backends need to be changed?

No response

tburgin avatar Oct 22 '25 18:10 tburgin