Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-07 Thread Dave Page
David Gardner wrote: As someone who would greatly benefit from this feature, is there something I can do to help out in development/testing of this feature? I have a test server I could install a cvs release of pgsql and know my way around a makefile. Hi David, At the moment it's just a case o

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-06 Thread David Gardner
- >> From: David Gardner <[EMAIL PROTECTED]> >> To: "'Dave Page'" <[EMAIL PROTECTED]> >> Sent: 06/06/07, 00:14:52 >> Subject: RE: pl/pgsql debuging, was Re: [GENERAL] debugging C functions >> >> I grabbed the May 10th dev sn

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-06 Thread Dave Page
> --- Original Message --- > From: David Gardner <[EMAIL PROTECTED]> > To: "'Dave Page'" <[EMAIL PROTECTED]> > Sent: 06/06/07, 00:14:52 > Subject: RE: pl/pgsql debuging, was Re: [GENERAL] debugging C functions > > I grabbed the May

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-05 Thread David Gardner
uging, was Re: [GENERAL] debugging C functions > --- Original Message --- > From: "Pavel Stehule" <[EMAIL PROTECTED]> > To: "David Gardner" <[EMAIL PROTECTED]> > Sent: 05/06/07, 21:01:49 > Subject: Re: pl/pgsql debuging, was Re: [GENERA

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-05 Thread Dave Page
> --- Original Message --- > From: "Pavel Stehule" <[EMAIL PROTECTED]> > To: "David Gardner" <[EMAIL PROTECTED]> > Sent: 05/06/07, 21:01:49 > Subject: Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions > > 2007/6/5, Da

Re: pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-05 Thread Pavel Stehule
2007/6/5, David Gardner <[EMAIL PROTECTED]>: This post got me thinking, is there a similar procedure for PL/pgSQL functions? No. You can debug PL/pgSQL function via debug plugin API. Currently exists only one debugger, which can do it - Enterprisedb debugger. Regards Pavel Stehule --

pl/pgsql debuging, was Re: [GENERAL] debugging C functions

2007-06-05 Thread David Gardner
: pgsql-general@postgresql.org Subject: Re: [GENERAL] debugging C functions Islam Hegazy wrote: > I wrote a C function to call from PostgreSQL8.2.4 under Linux. The > functions returns unexpected results. I did an extensive analysis to the > function and it seems correct. I want to know if

Re: [GENERAL] debugging C functions

2007-06-04 Thread Islam Hegazy
" <[EMAIL PROTECTED]> Cc: "Tom Lane" <[EMAIL PROTECTED]>; "Joe Conway" <[EMAIL PROTECTED]>; Sent: Monday, June 04, 2007 5:50 AM Subject: Re: [GENERAL] debugging C functions "Islam Hegazy" <[EMAIL PROTECTED]> writes: I do the same

Re: [GENERAL] debugging C functions

2007-06-04 Thread Islam Hegazy
<[EMAIL PROTECTED]>; "Joe Conway" <[EMAIL PROTECTED]>; Sent: Monday, June 04, 2007 5:50 AM Subject: Re: [GENERAL] debugging C functions "Islam Hegazy" <[EMAIL PROTECTED]> writes: I do the same but I use the ddd debugger 1) Load the shared library from the

Re: [GENERAL] debugging C functions

2007-06-04 Thread Gregory Stark
"Islam Hegazy" <[EMAIL PROTECTED]> writes: > I do the same but I use the ddd debugger > 1) Load the shared library from the SQL > 2) Open the .c file of my function > 3) Place the break points > 4) Execute the sql statement 'Select * from Myfn(...);' > > The result is displayed and the debugger do

Re: [GENERAL] debugging C functions

2007-06-03 Thread Islam Hegazy
there any steps missing? Regards Islam Hegazy - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Islam Hegazy" <[EMAIL PROTECTED]> Cc: "Joe Conway" <[EMAIL PROTECTED]>; Sent: Sunday, June 03, 2007 10:00 PM Subject: Re: [GEN

Re: [GENERAL] debugging C functions

2007-06-03 Thread Tom Lane
"Islam Hegazy" <[EMAIL PROTECTED]> writes: > Thanks for your replies, they were very helpful to me. Unfortuantely, I > can't trace the C function. PostgreSQL returns the results directly and the > debugger doesn't stop at the breakpoints in the C function. Well, you need to deal with that last,

Re: [GENERAL] debugging C functions

2007-06-03 Thread Islam Hegazy
"Tom Lane" <[EMAIL PROTECTED]> To: "Joe Conway" <[EMAIL PROTECTED]> Cc: "Islam Hegazy" <[EMAIL PROTECTED]>; Sent: Friday, June 01, 2007 11:38 PM Subject: Re: [GENERAL] debugging C functions Joe Conway <[EMAIL PROTECTED]> writes: [ much good a

Re: [GENERAL] debugging C functions

2007-06-01 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > [ much good advice snipped, but I have to weigh in on one point ] > 4. Start another console and determine the PID for the backend > session (this will wrap poorly -- I'll do my best to make it > readable) "select pg_backend_pid()" is another alter

Re: [GENERAL] debugging C functions

2007-06-01 Thread Joe Conway
Islam Hegazy wrote: I wrote a C function to call from PostgreSQL8.2.4 under Linux. The functions returns unexpected results. I did an extensive analysis to the function and it seems correct. I want to know if there is a way to debug C functions that are passed to PostgreSQL. Yes. Something al

[GENERAL] debugging C functions

2007-06-01 Thread Islam Hegazy
Hi there I wrote a C function to call from PostgreSQL8.2.4 under Linux. The functions returns unexpected results. I did an extensive analysis to the function and it seems correct. I want to know if there is a way to debug C functions that are passed to PostgreSQL. Thanks Islam

Re: [GENERAL] debugging C functions

2003-06-20 Thread Tom Lane
"Nigel J. Andrews" <[EMAIL PROTECTED]> writes: > ... I might not have tried the LOAD then attach gdb sequence. I think you need the "sharedlibrary" command to get gdb to know the symbols in a shlib that was loaded into the process after gdb first attached to it. If you do the LOAD, then attach, y