Re: Lost instrumentation functions

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: Joost Kraaijeveld <J(dot)Kraaijeveld(at)Askesis(dot)nl>, PgAdmin-support <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Lost instrumentation functions
Date: 2006-01-22 11:40:59
Message-ID: 43D36F4B.2070500@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Dave Page wrote:
>
>
>
>>-----Original Message-----
>>From: Joost Kraaijeveld [mailto:J(dot)Kraaijeveld(at)Askesis(dot)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.

That view is for pgadmin 1.2 compatibility only, not needed for 1.4.

SELECT pg_logdir_ls() should work.

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-01-22 11:42:17 Re: Lost instrumentation functions
Previous Message Dave Page 2006-01-22 10:36:22 Re: Lost instrumentation functions