BUG #14132: ON CONFLICT not inferring unique index with bigints - Mailing list pgsql-bugs

From fiercetuba@protonmail.com
Subject BUG #14132: ON CONFLICT not inferring unique index with bigints
Date
Msg-id 20160510190350.2608.48667@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14132: ON CONFLICT not inferring unique index with bigints
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      14132
Logged by:          Reynold Smith
Email address:      fiercetuba@protonmail.com
PostgreSQL version: 9.5.2
Operating system:   Linux
Description:

This fails, but change bigint to int and it works fine.

```
CREATE TABLE testtable(
  a  serial PRIMARY KEY,
  b  bigint,
  c  bigint
);

CREATE UNIQUE INDEX super_unique_idx ON testtable( COALESCE(b, 0),
COALESCE(c, 0));

INSERT INTO testtable(b, c)
VALUES (1, 2)
ON CONFLICT ((COALESCE(b, 0)), (COALESCE(c, 0))) DO NOTHING;
```

pgsql-bugs by date:

Previous
From: 德哥
Date:
Subject: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Next
From: Euler Taveira
Date:
Subject: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema