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

Поиск
Список
Период
Сортировка
От fiercetuba@protonmail.com
Тема BUG #14132: ON CONFLICT not inferring unique index with bigints
Дата
Msg-id 20160510190350.2608.48667@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14132: ON CONFLICT not inferring unique index with bigints  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: 德哥
Дата:
Сообщение: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema
Следующее
От: Euler Taveira
Дата:
Сообщение: Re: BUG #14131: BUG, schema owner can drop otheruser's object in it's schema