Lukasz Brodziak <lukasz.brodziak@xxxxxxxxx> wrote: > PostgreSQL version: 8.2.4 Major version 8.2 will be five years old in December, at which point it will be considered unsupported. It would be wise to have a plan to upgrade by then. http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy The current bug-fix level of 8.2 is 8.2.21. You are missing over four years of bug and security fixes. It's not unlikely that you would not be seeing this if you had kept up on minor (bug fix) releases. Whether an upgrade will make the problem go away without some sort of fix for what's now in the table is less certain. http://www.postgresql.org/support/versioning You can browse the fixes here: http://www.postgresql.org/docs/8.2/static/release.html > Exact message: 2011-07-08 09:50:29 ERROR: row is too big: size > 103400, maximum size 8136 > Table definition: > CREATE TABLE Insurance_cards > ( > card_no bigint NOT NULL, > card_dupl_no smallint NOT NULL, > card_type character varying(1) NOT NULL, > cancel_reason character varying(1) NOT NULL, > cancel_date date NOT NULL, > delete_date date, > CONSTRAINT pk_Insurance_cards > PRIMARY KEY (card_no, card_dupl_no) > ) > WITH (OIDS=FALSE); Well, there's no way you should be seeing wide rows on that table. > The problem is repeatable and consistant within this singular > database. Do you get the problem on SELECT count(*) FROM the table? How about CREATE TABLE x AS SELECT * FROM the table? You may be able to narrow down the affected row(s) by selecting ranges by primary key to see what works and what fails. I would also be wary of possible hardware issues on this box, but it's hard to point the finger in that direction with much certainty, given that you're running with such a large number of known bugs, without applying the fixes for them. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
