Breakpoints

You can set breakpoints in any function with an entry point known to your debugger.

Valid functions include internal functions and the UDRs in your shared-object file. The database server is compiled with debugging support turned off, so local storage and line number information is not available for UDRs. However, because you compiled the shared-object file for debugging, you can see line number information and local storage for your functions.

The database server routine that calls functions in your shared-object file is named udr_execute(). When you enter a command in the client application that calls one of your UDRs, the debugger stops in the udr_execute() routine. You can then step through your UDR. Because your shared-object file is compiled with debugging support, you can view the local variables and stack for your functions.

On UNIX™ or Linux™, you can set a breakpoint in the debugger utility on the udr_execute() function as follows: 
stop in udr_execute
cont