On Tue, May 22, 2012 at 5:41 AM, Chris Angelico <ros...@gmail.com> wrote: > > On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B > <jayashankar...@lnties.com> wrote: > > But here, the crash is happening right at the insert statement. That is > > insert itself is failing. > > Unless the insert is successful, stored procedure is not triggered. > > Hmm. I wonder is it possible that going past ID 999 and into a > four-digit number is causing stack damage that crashes the server a > few iterations later... many things are possible. I'd look at the code > of the procedure and see if there's any possible memory/stack issues.
Hm, on linux you check stack size with ulimit -s? If stack is set too low, a lower setting of max_stack_depth should prevent the crash. It's pretty hard to hit that unless you have extraordinarily complex and/or recursive functions though. Any chance of seeing the function source? merlin -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
