Re: Recommendations on plpgsql debugger?

One thing I've done in the past is to create a temporary table and insert "raise notice" debug statements to it, incrementing a sequence as it went along.  Then just select the message with order by the seq.  Useful in the recursive calls I was testing at the time.  But it did require that I stick a bunch of "raise notice" statements and reload the procedure(s).

But ya, a real debugger sould be great. 

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Chris Travers
Sent: Tuesday, January 15, 2013 3:00 AM
To: Postgres General
Subject: [GENERAL] Recommendations on plpgsql debugger?

Hi all;