Re: Catching unique_violation exception on specific column/index

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Catching unique_violation exception on specific column/index
Date: 2018-06-11 10:54:22
Message-ID: 5543f51d-870f-bae7-4f87-348819307d46@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 11.06.2018 um 12:58 schrieb Alexey Dokuchaev:
>> What's wrong with:
>>
>> INSERT ...
>> ON CONFLICT (foo_key) DO NOTHING
> Nothing I guess, except that it is available since 9.5 (right?), and I try
> to stay compatible with 9.3. Sorry for not saying this in the first place.
>
> ./danfe
>

... 9.3 will be out of support soon

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alexey Dokuchaev 2018-06-11 10:58:34 Re: Catching unique_violation exception on specific column/index
Previous Message Alexey Dokuchaev 2018-06-11 10:41:38 Re: Catching unique_violation exception on specific column/index