John DeSoi wrote:
Hi Dave,
On Sep 5, 2007, at 3:54 AM, Dave Page wrote:
That's odd - I cannot reproduce that on OS X using beta 4 (which has no
important changes in the debugger over beta 3).
Can you provide a simple test case?
I get the same error with this:
create or replace
Is there any documentation that describes how to use the SQL
functions? Some are obvious enough, but a simple example showing a
debugging session would be helpful.
John, I started writing up the API documentation and then noticed that
most of what I intended to write is already described in
Hi Korry,
On Sep 6, 2007, at 10:23 AM, korry.douglas wrote:
John, I started writing up the API documentation and then noticed
that most of what I intended to write is already described in the
pldbgapi.c module.
Take a look at that module and let me know if you have any
questions (you
John DeSoi wrote:
In some simple tests it seems to work OK with pgAdmin (1.8b3) on OS X.
There appears to be a pgAdmin bug when you start a debug session on a
function that has no parameters:
ERROR: syntax error at or near )
LINE 1: SELECT * FROM myschema.myfunction)
Hi Dave,
On Sep 5, 2007, at 3:54 AM, Dave Page wrote:
That's odd - I cannot reproduce that on OS X using beta 4 (which
has no
important changes in the debugger over beta 3).
Can you provide a simple test case?
I'll try to come up with a simple test case and send it sometime this
Is there any documentation that describes how to use the SQL
functions? Some are obvious enough, but a simple example showing a
debugging session would be helpful.
I'll add that to the README file and let you know when it's ready.
-- Korry
---(end of
Hi Dave,
On Sep 5, 2007, at 3:54 AM, Dave Page wrote:
That's odd - I cannot reproduce that on OS X using beta 4 (which
has no
important changes in the debugger over beta 3).
Can you provide a simple test case?
I get the same error with this:
create or replace function debug_test(out t
Now that we've announced (see
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375subSection=News)
that 8.3 will include a debugger (don't worry, it's a PL/pgSQL debugger
:-), has anyone actually tried it yet (other than myself and Dave Page)?
I would appreciate any
Hi Korry,
On Tue, 2007-09-04 at 10:07 -0400, korry.douglas wrote:
Now that we've announced
Could you please define we? Is it EDB or PostgreSQL ? I'm asking
this per a thread @ -advocacy list.
Cheers,
--
Devrim GÜNDÜZ
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
korry.douglas a écrit :
Now that we've announced (see
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375subSection=News)
that 8.3 will include a debugger (don't worry, it's a PL/pgSQL debugger
:-), has anyone actually tried it yet (other than myself and Dave Page)?
I
Ugaa...Sorry I don't have the margin of time.:-(
However, I examined it as EDB
Regards,
Hiroshi Saito
From: Guillaume Lelarge [EMAIL PROTECTED]
korry.douglas a écrit :
Now that we've announced (see
http://www.informationweek.com/news/showArticle.jhtml?articleID=201803375subSection=News)
Devrim GÜNDÜZ wrote:
Hi Korry,
On Tue, 2007-09-04 at 10:07 -0400, korry.douglas wrote:
Now that we've announced
Could you please define we? Is it EDB or PostgreSQL ? I'm asking
this per a thread @ -advocacy list.
We, EDB. Though I'm not sure it was so much announced as
Dave Page wrote:
Devrim GÜNDÜZ wrote:
Hi Korry,
On Tue, 2007-09-04 at 10:07 -0400, korry.douglas wrote:
Now that we've announced
Could you please define we? Is it EDB or PostgreSQL ? I'm asking
this per a thread @ -advocacy list.
We, EDB. Though I'm not sure it was so much announced as
Now that we've announced
Could you please define we? Is it EDB or PostgreSQL ? I'm asking
this per a thread @ -advocacy list.
That -advocacy thread is what got me started. I was referring to the
interview in InformationWeek - that's a PG-related interview not an
EDB-related
Hi Dave,
On Tue, 2007-09-04 at 15:55 +0100, Dave Page wrote:
We, EDB. Though I'm not sure it was so much announced as
mentioned-in-passing in all honesty.
I was referring to the source of the information in that article,
Dave :)
In any case, it's a plugin for PostgreSQL 8.2 and above that
Hello Korry
I test it and with pgAdmin and sent some bug reports (pgAdmin had some
problems not debugger).
Is it available without pgAdmin? Debugger works well, but integration
with pgAdmin is knotty now. Some points
1. can be integrated into psql?
2. can be started from query execution (with
In any case, it's a plugin for PostgreSQL 8.2 and above that allows
you to debug pl/pgsql functions using pgAdmin.
Yes I know and spent a bit time for testing it -- but not much.
Devrim, does that mean that you've tried it and it seemed to work? Did
you try it with 8.2 or 8.3?
Devrim GÜNDÜZ [EMAIL PROTECTED] writes:
On Tue, 2007-09-04 at 10:07 -0400, korry.douglas wrote:
Now that we've announced
Could you please define we? Is it EDB or PostgreSQL ? I'm asking
this per a thread @ -advocacy list.
It looks like We == Bruce. EDB isn't mentioned in the article, he
Pavel Stehule wrote:
Hello Korry
I test it and with pgAdmin and sent some bug reports (pgAdmin had some
problems not debugger).
Did you report the issues you had? I don't recall seeing anything.
1. can be integrated into psql?
Not without significant effort I would imagine - it's too
1. can be integrated into psql?
There is an API - I wouldn't want to try to use it from the
command-line, but you certainly can. You would call functions such as:
SELECT * FROM pldbg_set_breakpoint( 'myfunction' );
SELECT * FROM pldbg_wait_for_breakpoint( ... );
SELECT * FROM
Dave,
Or maybe in second thought Korry was actually referring the Information
Week article...
Yeah, I think so. The PL/pgSQL debugger was part of a list of 14-15 features
I gave Charles Babcock; not sure why he liked that one, but he did.
Last I talked to Korry, it was ready to go. No?
--
2007/9/4, korry.douglas [EMAIL PROTECTED]:
1. can be integrated into psql?
There is an API - I wouldn't want to try to use it from the command-line,
but you certainly can. You would call functions such as:
SELECT * FROM pldbg_set_breakpoint( 'myfunction' );
SELECT * FROM
Josh Berkus wrote:
Dave,
Or maybe in second thought Korry was actually referring the Information
Week article...
Yeah, I think so. The PL/pgSQL debugger was part of a list of 14-15 features
I gave Charles Babcock; not sure why he liked that one, but he did.
Last I talked to Korry, it
Pavel Stehule wrote:
1) In-context debugging: you set a breakpoint on a function (from within a
tool like pgAdmin) and then invoke that function from some other client
application
I mean method 1. I hadn't success with pgAdmin. Breakpoints was ignored.
That normally means the debugger
Yeah, I think so. The PL/pgSQL debugger was part of a list of 14-15 features
I gave Charles Babcock; not sure why he liked that one, but he did.
Last I talked to Korry, it was ready to go. No?
If by ready to go you mean has been exercised by a mess o' people, no.
If by ready to go you
Apologies - new list user, hit reply not reply all :-/
korry.douglas wrote:
Yeah, I think so. The PL/pgSQL debugger was part of a list of 14-15
features I gave Charles Babcock; not sure why he liked that one, but
he did.
Last I talked to Korry, it was ready to go. No?
If by ready to
The interview made it sound more mainstream. But then it did sound a
little disjointed too.
I suspect that it may go more mainstream in a later release, but it
seems way too late for 8.3.
Do we know if it going to be distributed with pgAdmin on Windows?
The graphical debugger client is part
korry.douglas wrote:
Looks great, and I'll be testing it shortly, but can I ask:
1. For 8.3 are we talking pgFoundry / contrib / core?
The server side of the debugger is implemented as a contrib module, but
not distributed with the PG core. You have to get it from pgFoundry,
untar it
korry.douglas wrote:
Do we know if it going to be distributed with pgAdmin on Windows?
The graphical debugger client is part of pgAdmin (on all platforms I
believe - Dave Page can say for sure).
Yes, it's fully integrated and supported on all platforms supported by
pgAdmin.
I don't know
Korry,
If by ready to go you mean has been tested by a few people and
compiled on a few platforms, that's where we are now - I would like to
see some more testing (especially on platforms other than Windows,
Linux, and OS X).
Well, if we don't publicize it at least a little, nobody will try
korry.douglas wrote:
Don't see the tracer, unless I'm missing what you mean.
You're right, it's not in the edb-debugger tarball. If you think you
might be interested, I can resurrect it.
Hmm - it's not that the plpgsql I write has complex control-flows, but
it might prove useful to others.
Gregory Stark wrote:
Devrim G?ND?Z [EMAIL PROTECTED] writes:
On Tue, 2007-09-04 at 10:07 -0400, korry.douglas wrote:
Now that we've announced
Could you please define we? Is it EDB or PostgreSQL ? I'm asking
this per a thread @ -advocacy list.
It looks like We == Bruce. EDB isn't
Josh Berkus wrote:
Dave,
Or maybe in second thought Korry was actually referring the Information
Week article...
Yeah, I think so. The PL/pgSQL debugger was part of a list of 14-15 features
I gave Charles Babcock; not sure why he liked that one, but he did.
Yea, it is very hard to
On Sep 4, 2007, at 1:01 PM, korry.douglas wrote:
The core of the debugger has been in use for quite some time, but I
had to strip out a lot of EDB-specific code and I'd like to see
that the result (the open-source version at pgFoundry) holds up
well on other platforms.
Josh, any chance
The core of the debugger has been in use for quite some time, but I
had to strip out a lot of EDB-specific code and I'd like to see that
the result (the open-source version at pgFoundry) holds up well on
other platforms.
Josh, any chance you could try it out on Solaris?
I copied the latest
On Sep 4, 2007, at 8:55 PM, korry.douglas wrote:
Sorry about that John, there's a fix for this problem (it's an 8.2
versus 8.3 issue) in the CVS repository. I thought I had rolled a
new tarball after committing the fix but I guess not.
You can pull the latest plugin_profiler.c from:
36 matches
Mail list logo
