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
We can understand the difference in shared buffer size as the Windows PC has 2GB of RAM and the board has 256MB of RAM. So please let us know if this shared buffer parameter has any relation to the problem we are facing. Thanks and Regards Jayashankar From: pgsql-general-ow...@postgresql.org [