Re: [HACKERS] unexpected and reproducable crash in pl/pgsql function

2005-03-03 Thread Merlin Moncure
> "Merlin Moncure" <[EMAIL PROTECTED]> writes: > > 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

Re: [HACKERS] unexpected and reproducable crash in pl/pgsql function

2005-03-03 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > 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 > serve

Re: [HACKERS] unexpected and reproducable crash in pl/pgsql function

2005-03-03 Thread Merlin Moncure
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

[HACKERS] unexpected and reproducable crash in pl/pgsql function

2005-03-03 Thread Merlin Moncure
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 machi