Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Merlin Moncure
On Tue, May 22, 2012 at 5:41 AM, Chris Angelico wrote: > > On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B > 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. >

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Chris Angelico
On Tue, May 22, 2012 at 8:23 PM, Jayashankar K B 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-

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Jayashankar K B
...@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 wrote: > On writing into this table, a stored procedure

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Chris Angelico
On Tue, May 22, 2012 at 4:51 PM, Jayashankar K B 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 th

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-22 Thread Craig Ringer
On 05/22/2012 01:57 PM, Jayashankar K B wrote: Please let us know why this crash is happening and how we can fix it. LOG: server process (PID 4016) was terminated by signal 11: Segmentation fault If you can't reproduce this crash on a more developer-friendly machine than your embedded syst

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
: Re: [GENERAL] Postgres process is crashing continously in 9.1.1 On 05/21/12 11:05 PM, Jayashankar K B wrote: > board with Coldfire controller. what is this board? Coldfire is the embedded 68k-like Freescale processor? what operating system is this under? what sort of storage does t

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread John R Pierce
On 05/21/12 11:05 PM, Jayashankar K B wrote: board with Coldfire controller. what is this board? Coldfire is the embedded 68k-like Freescale processor? what operating system is this under? what sort of storage does this embedded system use for the database? telling us FINANCIALWHATEVERI

Re: [GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
[mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayashankar K B Sent: Tuesday, May 22, 2012 11:27 AM To: pgsql-general@postgresql.org Subject: [GENERAL] Postgres process is crashing continously in 9.1.1 Hi, We are using Postgres 9.1.1 on a board with Coldfire controller. The postgres

[GENERAL] Postgres process is crashing continously in 9.1.1

2012-05-21 Thread Jayashankar K B
Hi, We are using Postgres 9.1.1 on a board with Coldfire controller. The postgres processes are crashing and restarting upon executing a particular instruction and it keeps repeating. Even when we tried with Postgres 9.1.3, same problem happens. It works fine until the FINANCIALTRANSACTIONID rea