Re: PL/PGSQL functions suddenly not working

Shridhar,
yes the behavior is a bit strange. I cant see much in the log except
that it says parse error  ad a date field which does not make sense to me.
It only accesses two tables  which are quite small.  The function fails
now when I run a heavy updated job so my feeling is that I either run
out of connections or memory related.

Alex

Shridhar Daithankar wrote:

> Alex wrote:
>
>> Hi,
>> I have a couple of functions in my database (v7.3.4) and noticed that
>> after a certain period of time, the functions fail to work This
>> happened now serveal times and the function fail at different points.
>> The did go away when I restarted the postmaster.  At one time the
>> function always failed when another heavy job was running on the system.
>>
>> Is this a bug? Does anybody have the same experience ?
>
>
> Can you provide more information? Schema, function bodies, relevant
> logs etc. It is hard to guess what could be wrong with it.
>
> For sure I find it pretty strange behaviour.
>
>  Shridhar
>
>
>