Disable log ERROR: duplicate key value violates unique constraint

Question

Running Postgresql in a better ask for forgiveness than permission mode during the inserts.

Works great, only problem: The logs are flooded with the following message

duplicate key value violates unique constraint

Is there a possibility to explictly disable this log?

There is a hook, emit_log_hook, that should allow an extension to do what you want. But I don't see any existing extensions which do it. github.com/harukat/pg_truncate_log_message does something a bit different, but perhaps could serve as a good starting point if you are interested. — jjanes
– jjanes, Commented Aug 27, 2019 at 15:55

Laurenz Albe · Accepted Answer · 2019-08-27 05:58:55Z

1

You could use

INSERT ... ON CONFLICT DO NOTHING

and check if a row was inserted or not.

answered Aug 27, 2019 at 5:58

Laurenz Albe

63k4 gold badges58 silver badges94 bronze badges

1 Answer 1