Re: edb-debugger, debugging pl/pgsql

From: "josep porres" <jmporres(at)gmail(dot)com>
To: "Dave Page" <dpage(at)pgadmin(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: edb-debugger, debugging pl/pgsql
Date: 2008-04-07 09:21:36
Message-ID: d2d532610804070221q386642cboe7aab89bf915abdb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

well, when you asked me about where I downloaded it, I downloaded it from I
installed it again.
It seems I can debug with no problems till now.
However, when I begin to debug and the function parameters window appears,
if I click cancel it freezes.

the log says:

2008-04-07 11:05:05 STATUS : Obteniendo Función detalles...
2008-04-07 11:05:05 STATUS : Obteniendo Función detalles... (0,01 seg)
2008-04-07 11:05:05 QUERY : Scalar query (192.168.1.3:5432): SELECT
count(*) FROM pg_proc WHERE proname = 'pldbg_get_target_info';
2008-04-07 11:05:05 QUERY : Query result: 1
2008-04-07 11:05:05 QUERY : Scalar query (192.168.1.3:5432): SELECT
count(*) FROM pg_proc WHERE proname = 'plpgsql_oid_debug';
2008-04-07 11:05:05 QUERY : Query result: 1
2008-04-07 11:05:08 QUERY : Scalar query (192.168.1.3:5432): SELECT
count(*) FROM pg_proc WHERE oid = 16439
2008-04-07 11:05:08 QUERY : Query result: 1
2008-04-07 11:05:08 QUERY : SET log_min_messages TO fatal
2008-04-07 11:05:08 QUERY : select t.*, pg_catalog.oidvectortypes(
t.argtypes ) as argtypenames, t.argtypes as argtypeoids, l.lanname,
n.nspname, p.proretset, y.typname AS rettype from pldbg_get_target_info(
'16439', 'o' ) t , pg_namespace n, pg_language l, pg_proc p, pg_type y
where n.oid = t.schema and l.oid = t.targetlang and p.oid = t.target
and y.oid = t.returntype
2008-04-07 11:05:08 QUERY : SELECT version();

thanks dave

Josep Porres

2008/4/7, Dave Page <dpage(at)pgadmin(dot)org>:
>
> On Mon, Apr 7, 2008 at 9:40 AM, josep porres <jmporres(at)gmail(dot)com> wrote:
> > I downloaded it from:
> > http://www.postgresql.org/ftp/pgadmin3/release/v1.8.2/win32/
> > spaninsh http mirror
> >
> http://wwwmaster.postgresql.org/download/mirrors-ftp?file=%2Fpgadmin3%2Frelease%2Fv1.8.2%2Fwin32%2Fpgadmin3-1.8.2-2.zip
> >
> > Is this version wrong?
>
>
> No, I forgot it got re-rolled.
>
> Can you supply a debug log showing pgAdmin hanging after you start
> debugging? Look under File -> Options -> Logging.
>
>
>
>
> --
>
> Dave Page
> EnterpriseDB UK: http://www.enterprisedb.com
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2008-04-07 09:36:43 Re: Numbering rows by date
Previous Message Dave Page 2008-04-07 09:02:29 Re: edb-debugger, debugging pl/pgsql