EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

ERROR: row is too big  XML

Forum Index » Advanced Server
Author Message
Paolo_Proni

New member

Joined: 12 Mar 2010 04:01:08
Messages: 1
Offline

Hello Everybody!

I am having a problem with EnterpriseDB Advanced Server on Debian: I have a table with almost 600 columns and I cannot change that. Trying to insert or update some data I get:

Error: ERROR: row is too big: size 8152, maximum size 8128
SQLState: 54000
ErrorCode: 0

If I recompile the PostgreSQL 8.4.2 sources, specifying "./configure --with-blocksize=32" it works! But how can I do it with EnterpriseDB?
Is there a packaged EnterpriseDB with 32Kb page size? Can I reach the same bahaviour, using some parameters or in some other way?

Should I substitute the actual EnterpriseDB in production with the recompiled PostgreSQL version ?

Can anybody help me?

Thank You in advance,
Paolo Proni
scottiebo

Senior member
[Avatar]

Joined: 23 Oct 2005 21:05:02
Messages: 197
Offline

You can't get a recompiled EnterpriseDB... but you really shouldn't recompile the postgresql core just for the blocksize. My guess is that you're using too many columns of fixed-sized data in your table (600 is a lot) Is there any way to normalize that table?


--Scottie
 
Forum Index » Advanced Server
Go to:   
Powered by JForum 2.1.8 © JForum Team