Thread: pgagent + faikure + Bug

Hy folks,<br /><br /> First I foud a bug.<br /> While I edit a jod and try to modify a step or a schedule from this
window,pgadmin crashed as I validate.<br /><br /> Then I have a probleme with the syntax of the steps.<br /> I created
afunction that is called each night : fn_myfunction (returns void)<br /> When I exexute <i>select fn_myfunction();</i>
inthe sql panel, everything is good.<br /> Unfortunately as I copy this command in the detail of the job, it's always
unsuccessfull.<br /> The message is : <i>function fn_myfunction doesn't exists</i><br /> Yet it exists in the database
asI could run the command directly. What kind of issue could it be?<br /> I work on a local database. In the job, I
precisedthe database I work with.<br /><br /> Thanks for your help<br /><br /> 

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