Horton

Re: PL/PGSQL functions suddenly not working

Shridhar Daithankar <shridhar_daithankar@persistent.co.in>

View thread View on postgr.es
From: Shridhar Daithankar <shridhar_daithankar@persistent.co.in>
To: Alex <alex@meerkatsoft.com>
Cc: pgsql-general@postgresql.org
Date: 2003-11-13T06:39:26Z
Lists: pgsql-general 
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