BUG #14132: ON CONFLICT not inferring unique index with bigints

From: fiercetuba(at)protonmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #14132: ON CONFLICT not inferring unique index with bigints
Date: 2016-05-10 19:03:50
Message-ID: 20160510190350.2608.48667@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 14132
Logged by: Reynold Smith
Email address: fiercetuba(at)protonmail(dot)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;
```

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Euler Taveira 2016-05-10 21:21:56 Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Previous Message 德哥 2016-05-10 15:55:48 Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema