Dave Page wrote:
-----Original Message-----
From: Joost Kraaijeveld [mailto:[EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
