We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see ourdocumentation.
There was an error while loading.Please reload this page.
1 parent17d3233 commited6e054Copy full SHA for ed6e054
doc/src/sgml/plpgsql.sgml
@@ -2561,7 +2561,10 @@ SELECT merge_db(1, 'dennis');
2561
2562
This coding assumes the <literal>unique_violation</> error is caused by
2563
the <command>INSERT</>, and not by, say, an <command>INSERT</> in a
2564
- trigger function on the table. More safety could be had by using the
+ trigger function on the table. It might also misbehave if there is
2565
+ more than one unique index on the table, since it will retry the
2566
+ operation regardless of which index caused the error.
2567
+ More safety could be had by using the
2568
features discussed next to check that the trapped error was the one
2569
expected.
2570
</para>