Re: RC2 needed?

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.


--
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com