RE: ON CONFLICT DO NOTHING on pg_dump
Ideriha, Takeshi <ideriha.takeshi@jp.fujitsu.com>
From: "Ideriha, Takeshi" <ideriha.takeshi@jp.fujitsu.com>
To: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Surafel Temesgen <surafel3000@gmail.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Dilip Kumar <dilipbalaut@gmail.com>
Date: 2018-07-13T02:46:54Z
Lists: pgsql-hackers
>I noticed one more thing: pg_dumpall.c doesn't really need to prohibit >--on-conflict-do-nothing without --insert. Its existing validation rejects illegal >combinations of the settings that are *not* passed on to pg_dump. It seems OK to >just pass those on and let pg_dump complain. For example, if you say "pg_dumpall >--data-only --schema-only", it's pg_dump that complains, not pg_dumpall. I think we >should do the same thing here. Thank you for the clarification. I didn't give thought to pg_dumpall internally running pg_dump. >Pushed, with those changes. Thanks!
Commits
-
Add pg_dump --on-conflict-do-nothing option.
- 387a5cfb94f0 12.0 landed