Re: pgagent + faikure + Bug

Le 04/01/2010 22:11, Florent THOMAS a écrit :
> Hy folks,
> 
> First I foud a bug.
> While I edit a jod and try to modify a step or a schedule from this
> window, pgadmin crashed as I validate.
> 

Which pgAdmin release? if 1.10.0, you should upgrade to 1.10.1. Some
bugs are fixed wrt pgagent dialogs.

> Then I have a probleme with the syntax of the steps.
> I created a function that is called each night : fn_myfunction (returns
> void)
> When I exexute select fn_myfunction(); in the sql panel, everything is
> good.
> Unfortunately as I copy this command in the detail of the job, it's
> always unsuccessfull. 
> The message is : function fn_myfunction doesn't exists
> Yet it exists in the database as I could run the command directly. What
> kind of issue could it be?

Did you specify the schema of the function? Not sure it needs to be told
explicitely, but that's the only issue I can find right now.

> I work on a local database. In the job, I precised the database I work
> with.
> 
> Thanks for your help
> 
> 


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