Postgres Pro
Downloads
Home   >   mailing lists

ON CONFLICT DO NOTHING on pg_dump - Mailing list pgsql-hackers

From Surafel Temesgen
Subject ON CONFLICT DO NOTHING on pg_dump
Date
Msg-id CALAY4q-PQ9cOEzs2+QHK5ObfF_4QbmBaYXbZx6BGGN66Q-n8FA@mail.gmail.com
Whole thread Raw
Responses RE: ON CONFLICT DO NOTHING on pg_dump
List pgsql-hackers
Tree view

Hello,

Sometimes I have to maintain two similar database and I have to update one from the other and notice having the option to add ON CONFLICT DO NOTHING clause to INSERT command in the dump data will allows pg_restore to be done with free of ignore error.

The attache patch add --on-conflect-do-nothing option to pg_dump in order to do the above.

regards

Surafel

Attachment

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: hot_standby_feedback vs excludeVacuum and snapshots
Next
From: Ashutosh Bapat
Date:
Subject: Re: Performance regression with PostgreSQL 11 and partitioning