Re: [GENERAL] How to debug pl/pgSQL -script?

2004-10-01 Thread Alvaro Herrera
On Fri, Oct 01, 2004 at 03:05:14PM +0200, Henriksen, Jonas F wrote: > I'm writing some simple triggers and functions for a postgres > database, and I'm wondering how to go about to debug a > pl/pgSQL-script. Is there a way to echo variable-content to screen, or > to file? Or is there other, more a

Re: [GENERAL] How to debug pl/pgSQL -script?

2004-10-01 Thread ra
Hi, http://www.postgresql.org/docs/7.4/static/plpgsql-errors-and-messages.html Albert ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[GENERAL] How to debug pl/pgSQL -script?

2004-10-01 Thread Henriksen, Jonas F
Hi, I'm writing some simple triggers and functions for a postgres database, and I'm wondering how to go about to debug a pl/pgSQL-script. Is there a way to echo variable-content to screen, or to file? Or is there other, more advanced ways of debugging such scripts? regards Jonas:)) -