Skip to content

[YSQL] [PG Compatibility] Conflict message dissimilarity #30992

@srinivasa-vasu

Description

@srinivasa-vasu

Description

PG

postgres=# create table err(k int primary key, v int);
CREATE TABLE
postgres=# insert into err values(1,1);
INSERT 0 1
postgres=# insert into err values(1,1);
ERROR:  duplicate key value violates unique constraint "err_pkey"
DETAIL:  Key (k)=(1) already exists.

YB

yugabyte=# create table err(k int primary key, v int);
CREATE TABLE
yugabyte=# insert into err values(1,1);
INSERT 0 1
yugabyte=# insert into err values(1,1);
ERROR:  duplicate key value violates unique constraint "err_pkey"

Additional Info:
DETAIL: Key (k)=(1) already exists.

The above info is emitted by PG whereas YB doesn't.

Issue Type

kind/bug

Warning: Please confirm that this issue does not contain any sensitive information

  • I confirm this issue does not contain any sensitive information.

Metadata

Metadata

Assignees

No one assigned

    Labels

    area/ysqlYugabyte SQL (YSQL)pg-compatibilityLabel for issues that result in differences b/w YSQL and Pg semantics

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions