Tips on how to efficiently debugging PL/PGSQL - Mailing list pgsql-general

From
Subject Tips on how to efficiently debugging PL/PGSQL
Date
Msg-id 2B4BE16C46894ED2B4CE4242C5D8C886@nc05072019
Whole thread Raw
In response to overhead of plpgsql functions over simple select  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: Tips on how to efficiently debugging PL/PGSQL  (Glyn Astill <glynastill@yahoo.co.uk>)
List pgsql-general
Just to seek some tips on how to efficiently debug PL/SQL.

One thing that bugs me in particular is the inability to trace a SQL line
number in an error message to the line in my PL/PGSQL code.

Thanks,
CYW



pgsql-general by date:

Previous
From: Jack Orenstein
Date:
Subject: Re: Postgres optimizer choosing wrong index
Next
From: "Otandeka Simon Peter"
Date:
Subject: Re: Import db from 8.1.3 to 8.3.1