Re: debugging plpgsql functions

From: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: debugging plpgsql functions
Date: 2009-01-17 11:32:11
Message-ID: gksfjr$trk$1@reversiblemaps.ath.cx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2009-01-12, Wright, George <George(dot)Wright(at)infimatic(dot)com> wrote:
> This is a multi-part message in MIME format.
>
> ------_=_NextPart_001_01C974C0.A3DF9B9A
> Content-Type: text/plain;
> charset="us-ascii"
> Content-Transfer-Encoding: quoted-printable
>
> What is the best way to debug plpgsql functions with versions of
> PostgreSQL prior to 8.2?

lots of "raise debug"
and careful counting of lines

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ridvan Lakas ng Bayan S. Baluyos 2009-01-19 10:36:16 Installing dblink
Previous Message John DeSoi 2009-01-15 15:06:04 Re: function transaction scope question