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

  1. Add pg_dump --on-conflict-do-nothing option.