Hi
>>>>> "JJ" == Jeff Janes writes:
JJ> This is a known issue and is fixed for 9.6 in commit
JJ> 8a7d0701814a4e.
thanks for the quick reply. Is there a chance this will get into the 9.5
branch as well?
Regards,
Julian v. Bock
--
Julian v. Bock
circumstances. It does no full table scan but
uses a few indexes.
The returned rows are among the rows that get deleted and inserted
repeatedly.
Regards,
Julian v. Bock
--
Julian v. Bock Projektleitung Software-Entwicklung
OpenIT GmbH Tel +49 211 239 577-0
In der Steele
r when the
row is inserted and the index is updated.
You can try the insert and catch the unique violation in a loop (see
http://www.postgresql.org/docs/9.1/static/plpgsql-control-structures.html)
although that won't work with a BEFORE trigger.
Regards,
Julian
--
Julian v. Bock