=> CREATE TABLE test (
id BIGSERIAL NOT NULL PRIMARY KEY,
name TEXT NOT NULL UNIQUE,
value TEXT
);
CREATE TABLE
=> INSERT INTO test (name, value) VALUES ('test', '1');
INSERT 0 1
=> INSERT INTO test (name, value) VALUES ('test', '1');
ERROR: duplicate key value violates unique constraint "test_name_key"
DETAIL: Key (name)=(test) already exists.
=> INSERT INTO test (name, value) VALUES ('test', '1') ON CONFLICT DO NOTHING;
INSERT 0 0
=> INSERT INTO test (name, value) VALUES ('test', '1') ON CONFLICT DO NOTHING RETURNING id;
id
----
(0 rows)
=> INSERT INTO test (name, value) VALUES ('test', '1') ON CONFLICT (name) DO UPDATE SET name = 'test' RETURNING id;
id
----
1
(1 row)
INSERT 0 1
=> SELECT version();
version
---------------------------------------------------------------------------------------------------
PostgreSQL 9.6.6 on x86_64-pc-linux-gnu, compiled by gcc (Debian 6.3.0-18) 6.3.0 20170516, 64-bit
(1 row)
Куда писать чтобы и в случае DO NOTHING id возвращался?.. Так как кажется - баг.