pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

plpgsql: debugging
2+ messages / 2 participants
[nested] [flat]

* plpgsql: debugging
@ 2003-01-24 02:38  Oliver Vecernik <vecernik@aon.at>
  0 siblings, 1 reply; 2+ messages in thread

From: Oliver Vecernik @ 2003-01-24 02:38 UTC (permalink / raw)
  To: pgsql-sql

Hi,

Searching Google I found a thread in July 2001 concerning the facilities 
for debugging plpgsql functions. The actual answer was: it should be 
improved.

What is the best way to debug a plpgsql function?

Oliver

-- 
VECERNIK Datenerfassungssysteme
A-2560 Hernstein, Hofkogelgasse 17
Tel.: +43 2633 47530, Fax: DW 50
http://members.aon.at/vecernik





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: plpgsql: debugging
@ 2003-01-24 07:41  Ludwig Lim <lud_nowhere_man@yahoo.com>
  parent: Oliver Vecernik <vecernik@aon.at>
  0 siblings, 0 replies; 2+ messages in thread

From: Ludwig Lim @ 2003-01-24 07:41 UTC (permalink / raw)
  To: Oliver Vecernik <vecernik@aon.at>; +Cc: pgsql-sql


--- Oliver Vecernik <vecernik@aon.at> wrote:
> Hi,
> 
> Searching Google I found a thread in July 2001
> concerning the facilities 
> for debugging plpgsql functions. The actual answer
> was: it should be 
> improved.
> 
> What is the best way to debug a plpgsql function?
> 
> Oliver

    This may not be the best way since its a bit
crude. Try using RAISE NOTICE every now then to
monitor the values of variables in the screen and
record it in log file.

    Example :

    RAISE NOTICE ''Initial value of variable =
%'',v_variable;

    /* Do some computation ... */

    RAISE NOTICE ''Value of variable after operation =
%'',v_variable;
    


hope that helps,

ludwig


__________________________________________________
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

end of thread, other threads:[~2003-01-24 07:41 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-01-24 02:38 plpgsql: debugging Oliver Vecernik <vecernik@aon.at>
2003-01-24 07:41 ` Ludwig Lim <lud_nowhere_man@yahoo.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox