By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE t1 (t1_id INT PRIMARY KEY);
CREATE TABLE t2 (t2_id INT PRIMARY KEY,
t1_id INT,
FOREIGN KEY (t1_id) REFERENCES t1 (t1_id));
WITH
cte AS ( INSERT INTO t1 (t1_id)
VALUES (11)
RETURNING t1_id)
INSERT INTO t2 (t2_id, t1_id)
SELECT 111, t1_id
FROM cte;
1 rows affected
SELECT * FROM t1;
SELECT * FROM t2;
| t1_id |
|---|
| 11 |
| t2_id | t1_id |
|---|---|
| 111 | 11 |