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

From Dave Cramer
Subject Re: Implementing SQL/PSM for PG 8.2 - debugger
Date
Msg-id E130AB13-DBF8-4673-865C-7D8D3C774EBB@fastcrypt.com
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,

What do you think you need for enhanced protocol ?

Dave
On 28-Jun-05, at 8:51 AM, Pavel Stehule wrote:

> On Tue, 28 Jun 2005, Dave Cramer wrote:
>
>
>> One thing bytecode would allow us to do is to write a debugger with
>> break points etc.
>>
>>
>
> We can write debugger with breakpoints without bytecode. Every stmt  
> rec
> can have flag if has breakpoints. No problem. I don't see any  
> advance of
> bytecode. Maybe, goto stmt is possible.
>
> What is problem? We need synchronous comunication (message) between
> backend frontend.
>
> I have idea (in exec_stmt()
>
>   CHECK_FOR_INTERRUPTS();
>   if (stmt->breakpoints)
>     estate->debug_mode = true;
>   if (estate->debug_mode)
>   {
>     for (;;)
>     {
>         rc = request_command();
>         switch (rc)
>         {
>             case 'c': -- continue
>                 estate->debug_mode = false;
>                 break
>             case 'q':
>                 elog(EXCEPTION, "stop debug");
>                 break;
>             case 'n':
>                 break;
>             case 'l':
>                   sendstring(line(estate->src,
>                     stmt->lineno));
>
> Please, can somebody help me with protocol enhancing? It is mayor  
> work on
> PL/pgSQL debugger (and plperl and plpython too).
>
>
>
>> Using a java jvm however is considerable overkill.
>>
>> Dave
>> On 27-Jun-05, at 8:28 PM, Neil Conway wrote:
>>
>>
>>> Jonah H. Harris wrote:
>>>
>>>
>>>> I don't recommend discussion for this in this thread, but it could
>>>> also tie in with the packages support we've discussed and
>>>> (although some may argue this), compiling the PL to bytecode and
>>>> using that.
>>>>
>>>>
>>>
>>> How would compilation to bytecode help?
>>>
>>> -Neil
>>>
>>> ---------------------------(end of
>>> broadcast)---------------------------
>>> TIP 5: Have you checked our extensive FAQ?
>>>
>>>               http://www.postgresql.org/docs/faq
>>>
>>>
>>>
>>
>>
>
>
>



pgsql-hackers by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Implementing SQL/PSM for PG 8.2 - debugger
Next
From: Peter Eisentraut
Date:
Subject: Re: Occupied port warning