Recommendations on plpgsql debugger?
Hi all;
I have a client who needs a way to step through a PL/PGSQL function and
ideally see what one is doing at present. I noticed that there used to be
an EDB Debugger module for this purpose but I can't seem to find one for
9.1 and I can't seem to pull from csv to try.
Any alternatives? Am I missing something?
Best Wishes,
Chris Travers
Chris Travers wrote:
I have a client who needs a way to step through a PL/PGSQL function and ideally see what one is doing
at present. I noticed that there used to be an EDB Debugger module for this purpose but I can't seem
to find one for 9.1 and I can't seem to pull from csv to try.Any alternatives? Am I missing something?
Did you look in http://git.postgresql.org/gitweb/?p=pldebugger.git ?
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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;
I have a client who needs a way to step through a PL/PGSQL function and ideally see what one is doing at present. I noticed that there used to be an EDB Debugger module for this purpose but I can't seem to find one for 9.1 and I can't seem to pull from csv to try.
Any alternatives? Am I missing something?
Best Wishes,
Chris Travers
Hi Chris
From: Chris Travers <chris.travers@gmail.com>
To: Postgres General <pgsql-general@postgresql.org>
Sent: Tuesday, 15 January 2013, 7:59
Subject: [GENERAL] Recommendations on plpgsql debugger?Hi all;
I have a client who needs a way to step through a PL/PGSQL function and ideally see what one is doing at present. I noticed that there used to be an EDB Debugger module for this purpose but I can't seem to find one for 9.1 and I can't seem to pull from csv to try.
Any alternatives? Am I missing something?
Yeah, the cvs repository appears to have been replaced with git instead, try doing a git clone from:
git://git.postgresql.org/git/pldebugger.git
Glyn
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general