27.04.2024 18:00, Alexander Lakhin wrote:
>
> Please look also at another script, which produces the same error:
I've discovered yet another problematic case:
CREATE TABLE tbl1 (a int GENERATED ALWAYS AS IDENTITY, b text)
PARTITION BY LIST (a);
CREATE TABLE tbl2 (b text, a int NOT NULL);
ALTER TABLE tbl1 ATTACH PARTITION tbl2 DEFAULT;
INSERT INTO tbl2 DEFAULT VALUES;
ERROR: no owned sequence found
Though it works with tbl2(a int NOT NULL, b text)...
Take a look at this too, please.
Best regards,
Alexander