Postgresql 6.5 Tuple is too big

Anon

Hi,

Here goes -

Running Pgsql 6.5, Redhat 6.1 PHP 3.0.15

Inserting Text into a text field from a web page using php & apache. It seems that when we insert a large amount of text (not that large) we get the following error:

Warning: PostgresSQL query failed: ERROR: Tuple is too big: size 9552 in <filename>.php

So we seem to be exceedinig the 8912 data page limit.

Any ideas/definitive answers how to work around/fix this this??

Updrade Postgresql to V??? on RH6.1 maybe?
Re-compile Postgres after delving in config.h?
Change from Text datatypes to BLOBS?

help.

cheers,

Joe.

smarlowe

Your best choice is to upgrade to Postgresql 7.2. It's much faster, more stable, and can handle infinite row sizes (limited by your storage only.) Plus it has many features that are lacking in 6.5.x, like making views that contain unions, outer joins, and things that I find now I wouldn't want to live without.

Anon

Cheers.

Do I have to rebuild PHP and Apache too?

I have upgraded to Postgresql 7.2.1
without rebuilding PHP and Apache an things seem to work OK, is this OK or am I asking for trouble??

rgds,

Joe.

smarlowe

You're probably ok. While there may be some minor changes in the interface API from 6.5.x to 7.2.1, you shouldn't have any serious issues because PHP doesn't really use them in a way that the changes would affect it.