Re: Postgres process is crashing continously in 9.1.1

Yes the board has the embedded 68k architecture based Freescale Coldfire processor.
The board has a custom built Linux based on the kernel 2.6.38
The database is stored on an SD card of 4GB capacity.

This is the table we have.
CREATE TABLE financialtransaction
(
FINANCIALTRANSACTIONID BIGINT NOT NULL PRIMARY KEY,
TIME_STAMP TIMESTAMP,
ATTENDANT SMALLINT,
RECEIPTPRINTED BOOLEAN DEFAULT FALSE,
ODOMETER VARCHAR(20),
ENGINEHOUR NUMERIC(9,2),
CONSTRAINT financialtransaction_pkey PRIMARY KEY (FINANCIALTRANSACTIONID )
)
WITH (
OIDS=FALSE
);
ALTER TABLE financialtransaction
OWNER TO postgres;

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.
Please let me know if you need any other information.

Thanks and Regards
Jayashankar

-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of John R Pierce
Sent: 22 May 2012 PM 12:00
To: pgsql-general(at)postgresql(dot)org
Subject: 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 this
embedded system use for the database?

telling us FINANCIALWHATEVERID > 1000 doesn't really do us much good since we have no idea what your database looks like, or what your code
is doing. the log seems to indicate there was a constraint violation
just before the exception hit.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)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 intended recipient, please do not use or disseminate the information, notify the sender and delete it from your system.

Earth Day. Every Day.