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. Thanks and regards Jayashankar -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of Chris Angelico Sent: Tuesday, May 22, 2012 3:10 PM To: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Postgres process is crashing continously in 9.1.1 On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B <Jayashankar.KB@xxxxxxxxxx> wrote: > On writing into this table, a stored procedure is triggered which inserts into another table. > But crash is happening while writing into this financialtransaction table once this table has more than 1000 records. What language is the stored procedure written in? Is it possible that it's that procedure that segfaults? Postgres experts, do stored procedure segfaults bring down the backend process like that? ChrisA -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general Larsen & Toubro Limited www.larsentoubro.com This Email may contain confidential or privileged information for the intended recipient (s). If you are not the intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system. Earth Day. Every Day. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
