> -----Original Message-----
> From: Andreas Pflug [mailtogadmin@pse-consulting.de]
> Sent: 22 January 2006 11:56
> To: Dave Page
> Cc: Joost Kraaijeveld; PgAdmin-support
> Subject: Re: [pgadmin-support] Lost instrumentation functions
>
> Dave Page wrote:
> >
> >
> >
> >>-----Original Message-----
> >>From: Andreas Pflug [mailtogadmin@pse-consulting.de]
> >>Sent: 22 January 2006 11:41
> >>To: Dave Page
> >>Cc: Joost Kraaijeveld; PgAdmin-support
> >>Subject: Re: [pgadmin-support] Lost instrumentation functions
> >>
> >>That view is for pgadmin 1.2 compatibility only, not needed for 1.4.
> >>
> >>SELECT pg_logdir_ls() should work.
> >
> >
> > Yes, but the view should still be there as it's in the
> script. If not,
> > something fishy is afoot.
>
> It's commented out...

Blergh. :-)

/D

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Hi Dave,

If I run this query

select * from pg_logdir_ls() as (filetime timestamp, filename text)

I get the following response:

ERROR: /var/lib/postgresql/8.1/main/pg_log is not browsable: Not a
directory

This suggest that the function is available (but not working ;-))



--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl





---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Joost Kraaijeveld wrote:
> Hi Dave,
>
> If I run this query
>
> select * from pg_logdir_ls() as (filetime timestamp, filename text)
>
> I get the following response:
>
> ERROR: /var/lib/postgresql/8.1/main/pg_log is not browsable: Not a
> directory
>
> This suggest that the function is available (but not working ;-))

I bet /var/lib/postgresql/8.1/main/pg_log is not a directory... Did you
enable redirect_stderr? The function is working as expected in this
situation.

Please note that pgadmin expects its functions to be existent in the
_maintenance_ DB, for 8.1 usually postgres.

Regards,
Andreas

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Hi Andreas,

On Sun, 2006-01-22 at 18:26 +0100, Andreas Pflug wrote:
> Joost Kraaijeveld wrote:

> I bet /var/lib/postgresql/8.1/main/pg_log is not a directory... Did you
> enable redirect_stderr? The function is working as expected in this
> situation.
Not, that is not my problem, hence the ;-). The problem is that PgAdmin
does not find the instrumentation functions while they are there (I get
the Guru hint).


--
Groeten,

Joost Kraaijeveld
Askesis B.V.
Molukkenstraat 14
6524NB Nijmegen
tel: 024-3888063 / 06-51855277
fax: 024-3608416
e-mail: J.Kraaijeveld@Askesis.nl
web: www.askesis.nl



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster