> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailtogadmin-support-owner@postgresql.org] On Behalf Of
> Joost Kraaijeveld
> Sent: 22 January 2006 08:20
> To: PgAdmin-support
> Subject: [pgadmin-support] Lost instrumentation functions
>
> Hi,
>
> After an upgrade of PostgreSQL 8.1.0 to 8.1.2 I lost the
> instrumentation
> functions.

Weird.

> Recompiling and reinstalling does not restore the
> functionality. I have
> looked in the log files of PostgreSQL and PgAdmin for clues
> but I cannot
> find anything.
>
> What can I do to:
> 1. Better diagnose problems with non-loading/working PostgreSQL
> libraries?

Darned if I know. I've had a heck of a job diagnosing this sort of
problem in the past :-(.

> 2. Get the instrumentation functions working again?

Do the function definitions actually exist in your master database? If
so, do they work? Try 'select * from pg_logdir_ls()' to test. If so,
then it would appear that pgAdmin just isn't detecting them for some
reason.

Regards, Dave.

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

Hi Dave,

On Sun, 2006-01-22 at 08:51 +0000, Dave Page wrote:

> Do the function definitions actually exist in your master database? If
Yep, they do.

> so, do they work? Try 'select * from pg_logdir_ls()' to test. If so,

This returns:
ERROR: a column definition list is required for functions returning
"record"

The other function that is installed by admin81.sql and that is callable
without arguments ("select * from pg_catalog.pg_logfile_rotate()")
returns "0"

--
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 4: Have you searched our list archives?

http://archives.postgresql.org