Re: Implementing SQL/PSM for PG 8.2 - debugger - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Implementing SQL/PSM for PG 8.2 - debugger
Date
Msg-id 14668.1119966680@sss.pgh.pa.us
Whole thread Raw
In response to Re: Implementing SQL/PSM for PG 8.2 - debugger  (Pavel Stehule <stehule@kix.fsv.cvut.cz>)
Responses Re: Implementing SQL/PSM for PG 8.2 - debugger
List pgsql-hackers
Pavel Stehule <stehule@kix.fsv.cvut.cz> writes:
>> What do you think you need for enhanced protocol ?

> What I need? Some like synchronous elog(NOTICE,''), which can return some 
> user's interaction, if it's possible. I didn't find how I do it with 
> current set of messages. But my knowleadges of protocol are minimal.

It'd probably be smarter to manage the debugging across a separate
connection, so that you could carry out debugging without requiring
sophisticated support for it inside the client program.  If it's
single-connection then it will be essentially impractical to debug
except from a few specialized clients such as pgadmin; which will
make it hard to investigate behaviors that are only seen under load
from a client app.

I don't know exactly how to cause such a connection to get set up,
especially remotely.  But we should try to think of a way.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Occupied port warning
Next
From: Tom Lane
Date:
Subject: Re: Occupied port warning