Hi there,
I went thru all the mailing list archives and other
documentation and found the way to increase the max
tuple size clearly as " change the BLCKSZ to ...."
I did that and even created a new data directory and
cluster by using init_db but the error 
psql:ins.sql:173: ERROR:  Tuple is too big: size 9148,
max size 8140 
still persists. 

My question is that is there a way to reflect the
chages to config.h in the database without
re-istalling  postgresql. I have a large database
running on 7.03 and do not want to reinstall. 
PLEASE HELP !!!!!!!
Thanks
Nick

__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
http://shopping.yahoo.com/

Thu, 14 Dec 2000 22:30:19 -0800 (PST)
Nick Wayne <nick_wayne@yahoo.com>
BLCKSZ:Max tuple size problem
Nick Wayne <nick_wayne@yahoo.com> writes:
> I went thru all the mailing list archives and other
> documentation and found the way to increase the max
> tuple size clearly as " change the BLCKSZ to ...."
> I did that and even created a new data directory and
> cluster by using init_db but the error 
> psql:ins.sql:173: ERROR:  Tuple is too big: size 9148,
> max size 8140 
> still persists. 

Sounds like you didn't do the rebuild correctly.  The full recipe is

1. Change BLCKSZ in include/config.h (after running configure).
2. Do a *full* compilation.  If you compiled already, do "make clean"
   before "make all".  Do not rely on make dependencies, because there
   aren't any.
3. Install.
4. initdb.

> My question is that is there a way to reflect the
> chages to config.h in the database without
> re-istalling  postgresql.

No.  Page size is a pretty fundamental thing...

			regards, tom lane

Fri, 15 Dec 2000 11:12:49 -0500
Tom Lane <tgl@sss.pgh.pa.us>
Re: BLCKSZ:Max tuple size problem 