Skip to content

postgres 17: support ON_ERROR with :copyfrom #4151

@tburgin

Description

@tburgin

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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions