Database Reference
In-Depth Information
These attributes, taken together, make
RAISE
a very attractive tool for small-scale
debugging.
Disadvantages of RAISE NOTICE
Unfortunately, there are some disadvantages to using this method of debugging. The
primary disadvantage is remembering to remove the
RAISE
statements when they
are no longer necessary. The messages tend to clutter up the
psql
command-line
client, and are generally annoying to other developers. The log may fill up quickly
with useless messages from previous debug sessions.
RAISE
statements need to
be written, commented out, and restored when needed. They may not cover the ac-
tual bug being sought. They also slow down the execution of the routine.