The following bug has been logged on the website:
Bug reference: 14421
Logged by: Stepan Perlov
Email address: stepanperlov(at)gmail(dot)com
PostgreSQL version: 9.5.5
Operating system: ubuntu 14.04
Description:
Hello
CREATE TABLE test(
id bigserial PRIMARY KEY,
parent bigint REFERENCES test(id) ON DELETE CASCADE ON UPDATE CASCADE
);
INSERT INTO test VALUES (1, null);
INSERT INTO test VALUES (2, 1);
INSERT INTO test VALUES (3, 2);
INSERT INTO test VALUES (4, 2);
INSERT INTO test VALUES (5, 2);
INSERT INTO test VALUES (6, 2);
INSERT INTO test VALUES (7, 2);
DELETE FROM test
WHERE id = 2
RETURNING id;
Returns:
id
2
I expect:
id
2
3
4
5
6
7
Thanks