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?.
10006 rows affected
ERROR: index "book1_pattern_ops" column number 1 does not have default sorting behavior
LINE 3: , ADD CONSTRAINT book1_uni UNIQUE USING IND...
^
DETAIL: Cannot create a primary key or unique constraint using such an index.
3 rows affected
book_id | book |
---|---|
1 | foo |
2 | Foo |
book_id | book |
---|---|
1 | V4Ht,F,184 |
2 | 6La3VR<87 |
3 | kk$@=F477 |
4 | uIC;BGZ273 |
5 | p|4,C394 |
book_id | book |
---|---|
10002 | foo |
10006 | footaststic |
book_id | book |
---|---|
10002 | foo |
10003 | Foo |
10005 | FOObar |
10006 | footaststic |