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@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Chris Angelico
Sent: Tuesday, May 22, 2012 3:10 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Postgres process is crashing continously in 9.1.1
On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B <Jayashankar.KB@lnties.com> 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@postgresql.org) 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
intendedrecipient, please do not use or disseminate the information, notify the sender and delete it from your system.
Earth Day. Every Day.