From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgagent + faikure + Bug |
Date: | 2010-01-04 22:02:22 |
Message-ID: | 4B42656E.3090401@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.org
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2010-01-05 16:40:53 | Re: PgAdmin Crash |
Previous Message | Guillaume Lelarge | 2010-01-04 21:59:33 | Re: PgAdmin Crash |