Re: Proposal for debugging of server-side stored procedures

From: "Mark Cave-Ayland" <m(dot)cave-ayland(at)webbased(dot)co(dot)uk>
To: "'Andrew Dunstan'" <andrew(at)dunslane(dot)net>
Cc: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Proposal for debugging of server-side stored procedures
Date: 2006-06-10 12:33:44
Message-ID: 200606101233.k5ACXno30431@webbased16.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> -----Original Message-----
> From: Andrew Dunstan [mailto:andrew(at)dunslane(dot)net]
> Sent: 09 June 2006 17:01
> To: Mark Cave-Ayland
> Cc: 'Tom Lane'; pgsql-hackers(at)postgresql(dot)org
> Subject: Re: [HACKERS] Proposal for debugging of server-side stored
> procedures

(cut)

> Debugging embedded perl has some significant challenges. You might find
> it interesting to see what can be done in the most famous embedded
> situation: mod_perl. See http://perl.apache.org/docs/1.0/guide/debug.html
>
> using ptkdb might be nice ....
>
> cheers
>
> andrew

Hi Andrew,

Thanks for the link. This brings up another issue - what if someone wishes
to debug locally using their favourite tool rather than a PostgreSQL tool?
Should this be allowed even if it may circumvent PostgreSQL's user
permissions on functions within the database?

Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk
http://www.infomapper.com
http://www.swtc.co.uk

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Paul Lindner 2006-06-10 12:44:37 Latest timezone data in 8.1.4
Previous Message Mark Cave-Ayland 2006-06-10 12:33:08 Re: Proposal for debugging of server-side stored procedures