Re: Debugging code on server?

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 <guyren(at)gmail(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>