Re: Lost instrumentation functions
This is a discussion on Re: Lost instrumentation functions within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> > -----Original Message----- > From: Joost Kraaijeveld [mailto:J.Kraaijeveld@Askesis.nl] > Sent: 22 January 2006 10:00 > To: Dave Page > ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 08:19 PM
| ||||
| ||||
 Re: Lost instrumentation functions > -----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/viewc...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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend      |
|
04-17-2008, 08:19 PM
| ||||
| ||||
| Re: Lost instrumentation functions Dave Page wrote: > > > >>-----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/viewc...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 |
Linear Mode
