I wrote:
> Ok, I have a fairly nasty situation.  I am having a production server
> that is crashing upon execution of a pl/pgsql function...on code that
> has been working flawlessly for weeks.  My production server is
running
> 8.0 on win32 and I was able to 'sort-of' reproduce the behavior on my
> development machine here at the office.

Ok, problem was due to recursive pl/pgsql function and a recursion loop
in the data.  I traced this problem to the data: somebody disabled the
recursion check constraint.  

I've never had this actually happen before.  It totally nuked the
server.

Merlin

Responses

• Re: unexpected and reproducable crash in pl/pgsql function at 2005-03-03 21:20:00 from Tom Lane

pgsql-hackers by date

Next:	From: Tom Lane	Date: 2005-03-03 21:17:00
	Subject: Re: logging as inserts
Previous:	From: Josh Berkus	Date: 2005-03-03 21:02:29
	Subject: Re: logging as inserts

pgsql-hackers-win32 by date

Next:	From: Tom Lane	Date: 2005-03-03 21:20:00
	Subject: Re: unexpected and reproducable crash in pl/pgsql function
Previous:	From: Merlin Moncure	Date: 2005-03-03 19:47:59
	Subject: unexpected and reproducable crash in pl/pgsql function