Re: PL/PGSQL functions suddenly not working - Mailing list pgsql-general

From Shridhar Daithankar
Subject Re: PL/PGSQL functions suddenly not working
Date
Msg-id 3FB3271E.4020405@persistent.co.in
Whole thread Raw
In response to PL/PGSQL functions suddenly not working  (Alex <alex@meerkatsoft.com>)
List 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


pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: embedded postgresql
Next
From: Shridhar Daithankar
Date:
Subject: Re: PGexec dumps core at pqResultAlloc