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

"Merlin Moncure" <[email protected]>
Newsgroups gmane.comp.db.postgresql.devel.win32,gmane.comp.db.postgresql.devel.general
Message-ID <[email protected]>
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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.