Insert duplicate rows

[schalimidi]

Failing to write duplicate values in a single transaction.
Error { kind: Db, cause: Some(DbError { severity: "ERROR", parsed_severity: Some(Error), code: SqlState(E23505), message: "duplicate key value violates unique constraint

I'm using binarycopyinwriter to insert values into table

[weiznich]

It's not clear what you are asking for. Please at at least the following details to your questions:

• Information about your diesel version
• Information about your rustc version
• Information about your operating system
• Information about your database system (which one is used + what version)
• Relevant parts of your schema, code, … (Minimal self contained reproducible example)

[schalimidi]

. Diesel Version 2.2.0
. Rustc Version 1.82.0
. Mac OS
. PostgreSQL 15

create table items(
col1 int not null,
col2 text not null,
col3 text not null,
col4 text not null,
constraint items_pkey PRIMARY KEY (col1, col3)
} PARTITON BY LIST (Col3)

INSERT INTO items
Values (1, test, test, test)
Values( 1, test, test, test)

SQL statement for BinaryCopyIn:
COPY items (col1, col2, col3, col4) FROM STDIN BINARY

I am expecting only one record in my database but it error out with "duplicate key value violates unique constraint" message

[weiznich]

Well that error is expected as you literally insert the same value twice in your SQL INSERT command.