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?.
1 rows affected
ERROR: duplicate key value violates unique constraint "tag_attributes_pkey"
DETAIL: Key (id)=(99c5bbfc-c1a0-4ca5-9cf2-b884ada6ab1f) already exists.
1 rows affected
id | column1 | column2 | hot1 | hot2 | hot3 |
---|---|---|---|---|---|
99c5bbfc-c1a0-4ca5-9cf2-b884ada6ab1f | key1 | value1 | var1 | var1 | var1 |
id | column1 | column2 | hot1 | hot2 | hot3 |
---|---|---|---|---|---|
99c5bbfc-c1a0-4ca5-9cf2-b884ada6ab1f | key1 | value1 | var2 | var2 | var2 |