Hi Andreas,
On Sun, 2006-01-22 at 18:26 +0100, Andreas Pflug wrote:
> Joost Kraaijeveld wrote:
> I bet /var/lib/postgresql/8.1/main/pg_log is not a directory... Did you
> enable redirect_stderr? The function is working as expected in this
> situation.
Not, that is not my problem, hence the ;-). T
Joost Kraaijeveld wrote:
Hi Dave,
If I run this query
select * from pg_logdir_ls() as (filetime timestamp, filename text)
I get the following response:
ERROR: /var/lib/postgresql/8.1/main/pg_log is not browsable: Not a
directory
This suggest that the function is available (but not working ;
Hi Dave,
If I run this query
select * from pg_logdir_ls() as (filetime timestamp, filename text)
I get the following response:
ERROR: /var/lib/postgresql/8.1/main/pg_log is not browsable: Not a
directory
This suggest that the function is available (but not working ;-))
--
Groeten,
Joost
> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Sent: 22 January 2006 11:56
> To: Dave Page
> Cc: Joost Kraaijeveld; PgAdmin-support
> Subject: Re: [pgadmin-support] Lost instrumentation functions
>
> Dave Page wrote:
> >
>
Dave Page wrote:
-Original Message-
From: Andreas Pflug [mailto:[EMAIL PROTECTED]
Sent: 22 January 2006 11:41
To: Dave Page
Cc: Joost Kraaijeveld; PgAdmin-support
Subject: Re: [pgadmin-support] Lost instrumentation functions
That view is for pgadmin 1.2 compatibility only, not
> -Original Message-
> From: Andreas Pflug [mailto:[EMAIL PROTECTED]
> Sent: 22 January 2006 11:41
> To: Dave Page
> Cc: Joost Kraaijeveld; PgAdmin-support
> Subject: Re: [pgadmin-support] Lost instrumentation functions
>
> That view is for pgadmin 1.2 compat
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 +, Dave Page wrote:
Sorry- try
> -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 +, Dave Page
On Sun, 2006-01-22 at 09:34 +, 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 f
> -Original Message-
> From: Joost Kraaijeveld [mailto:[EMAIL PROTECTED]
> Sent: 22 January 2006 09:23
> To: Dave Page
> Cc: PgAdmin-support
> Subject: RE: [pgadmin-support] Lost instrumentation functions
>
> Hi Dave,
>
> On Sun, 2006-01-22 a
Hi Dave,
On Sun, 2006-01-22 at 08:51 +, 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 r
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Joost Kraaijeveld
> Sent: 22 January 2006 08:20
> To: PgAdmin-support
> Subject: [pgadmin-support] Lost instrumentation functions
>
> Hi,
>
> After an upgra
Hi,
After an upgrade of PostgreSQL 8.1.0 to 8.1.2 I lost the instrumentation
functions.
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
13 matches
Mail list logo
