> ------- Original Message -------
> From: Guillaume Lelarge <guillaume@lelarge.info>
> To: Dave Page <dpage@postgresql.org>
> Sent: 15/10/07, 17:18:28
> Subject: Re: [pgadmin-hackers] RC2 needed?
>
> Dave Page a écrit :
> > Guillaume Lelarge wrote:
> >> Dave Page a écrit :
> >>> Guillaume Lelarge wrote:
> >>>> First, you'll need to install some stuff :
> >>>> * create a postgres database ;
> >>>> * change the pgagent.sql file (there's a dollar quote function that
> >>>> disallow it to be used where pre-8.0 release) ;
> >>>> * launch pgagent like this :
> >>>> pgagent hostaddr=IP_ADDR dbname=postgres
> >>> There's no need to run pgagent itself. All the changed code is in pgAdmin.
> >>>
> >>>> Then
> >>>> * launch pgAdmin
> >>>> * create a job (http://www.pgadmin.org/docs/dev/pgagent-jobs.html)
> >>>>
> >>>> To be honest, I don't find the pgagent interface when I use my 7.4 and
> >>>> 8.1 cluster. This will take more time than I first thought.
> >>> Make sure you run the SQL file in the maintenance DB.
> >>>
> >> I found the issue with your last email. The maintenance DB was still
> >> template1.
> >>
> >> I can add a job but, even after a refresh, I can't see it. I only gave a
> >> name to my job and click OK. So, it seems the SELECT DISTINCT returns
> >> nothing.
> >
> > Rats - could have sworn I tested that but I must have done something
> > stupid. Please try with SVN trunk - it should be OK now.
> >
>
> Works on 7.4 and 8.1. I'll commit my fix on the dollar quoting stuff if
> you don't mind. It'll allow 7.4 users to use pgAgent.
Ok, thanks.
/D