Good old fashioned "print" :) I tend to use RAISE DEBUG, and look in the logs. The most complicated procedures we have in our system are enforcing state diagram changes for a given field that tracks an object status, so maybe this doesn't scale well.
On Wed, May 4, 2016 at 12:43 PM, Guyren Howe <guy...@gmail.com> wrote: > This is a fork from my "Love your database" question. It's a separable > concern, so I moved it here. > > Let's say I want to use Postgres' *amazing* support for lots of languages. > I want to use Javascript or PERL or Ruby or something. How do I debug the > code? > > I can imagine things you might set up: using LISTEN/NOTIFY to a simple > logger that would let you see what's going on. There are breakpoints and > such in PGAdmin, but I'll be that doesn't work for other languages. > > Any thoughts? > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
