Skip to content

ON CONFLICT clause is not supported with partitioned tables #226

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Open
farons opened this issue Dec 14, 2020 · 0 comments
Open

ON CONFLICT clause is not supported with partitioned tables #226

farons opened this issue Dec 14, 2020 · 0 comments

Comments

@farons
Copy link

farons commented Dec 14, 2020

postgres 12.5
An error occurred when I tried to use upsert to update my main table;
but when I use the traditional way:
CREATE TABLE o(id INT PRIMARY KEY, i INT) PARTITION BY RANGE (id);
CREATE TABLE o1 PARTITION OF o FOR VALUES FROM (1) TO (1000);
CREATE TABLE o2 PARTITION OF o FOR VALUES FROM (1000) TO (2000);

INSERT INTO o(id, i) VALUES (1,1),(2,2),(1500,1500);

INSERT INTO o(id, i)
VALUES (1500, 1400), (2,20), (3, 3)
ON CONFLICT (id)
DO UPDATE SET i = EXCLUDED.i; it is ok.
why?

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant