Re: Lost instrumentation functions - Mailing list pgadmin-support

From Dave Page
Subject Re: Lost instrumentation functions
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40103D9EB@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Lost instrumentation functions  (Joost Kraaijeveld <J.Kraaijeveld@Askesis.nl>)
Responses Re: Lost instrumentation functions
List pgadmin-support

> -----Original Message-----
> From: Joost Kraaijeveld [mailto:J.Kraaijeveld@Askesis.nl]
> Sent: 22 January 2006 10:00
> To: Dave Page
> Cc: PgAdmin-support
> Subject: RE: [pgadmin-support] Lost instrumentation functions
>
> On Sun, 2006-01-22 at 09:34 +0000, Dave Page wrote:
>
> > Sorry- try without the brackets - that's a view that uses
> the function
> > to retrieve 3 columns.
> Mmmm. "select * from pg_logdir_ls;" returns:
> ERROR:  relation "pg_logdir_ls" does not exist
>
> But the function exists (I can see all the functions from admin81.sql
> with pgadmin in the tree), so it is likely that it is not the correct
> syntax. As far as I know one must call a function with brackets e.g.
> "select * from now();".

Yes, but there should be a view with the same name - see the bottom of
the SQL script:

http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/trunk/pgadmin3/xtra/admin81/a
dmin81.sql.in?rev=4475&view=markup

That should call the function with the correct syntax and prove whether
or not it's working.

Regards, Dave


pgadmin-support by date:

Previous
From: Joost Kraaijeveld
Date:
Subject: Re: Lost instrumentation functions
Next
From: Andreas Pflug
Date:
Subject: Re: Lost instrumentation functions