large tuple
I set BLCKSZ to 32768, as described in FAQ question 4.6,
recompiled and reinstalled the system, and ran initdb, and I
am still getting the error "Tuple is too big: size 9588, max
size 8140".
I am using 7.0.2 on a modified RedHat 6.0 (with glibc
upgraded to 2.1.3).
Any ideas why that would be? Is there also something else I
need to do?
Is there a way to check at runtime what BLCKSZ the system is
using?
Thank you.
Ken
p.s. Sorry if this is a repeat of a previous message that I
hadn't thought was delivered properly.
Well, I solved this problem by doing two things:
1. I used 16384 instead of 32768. I can't imagine this made
any difference.
2. I ran "make clean" before running "make". Maybe there is
a problem with the dependencies in the makefiles?
Ken
Kenneth Been wrote:
Show quoted text
I set BLCKSZ to 32768, as described in FAQ question 4.6,
recompiled and reinstalled the system, and ran initdb, and I
am still getting the error "Tuple is too big: size 9588, max
size 8140".I am using 7.0.2 on a modified RedHat 6.0 (with glibc
upgraded to 2.1.3).Any ideas why that would be? Is there also something else I
need to do?Is there a way to check at runtime what BLCKSZ the system is
using?Thank you.
Ken
p.s. Sorry if this is a repeat of a previous message that I
hadn't thought was delivered properly.
Kenneth Been <kennethb@telocity.com> writes:
2. I ran "make clean" before running "make". Maybe there is
a problem with the dependencies in the makefiles?
There are no dependencies in the Makefiles, unless you did "make
depend". "make clean" is usually necessary after changing any
widely-used header file...
regards, tom lane
Kenneth Been <kennethb@telocity.com> wrote:
I set BLCKSZ to 32768, as described in FAQ question 4.6, and
recompiled and reinstalled the system, and I am still
getting the error "Tuple is too big: size 9588, max size
8140".
Kenneth,
do you access postgresQL via ODBC? There is a tuple size setting
for the ODBC driver. Maybe you have to adjust it, too.
Peter.
--
------------------------------------------------------------------
Peter Maas, m+r infosysteme, D-52070 Aachen, Hubert-Wienen-Str. 24
Tel +49-241-875094 Fax +49-241-875095 eMail pm@mrinfo.de
------------------------------------------------------------------
Import Notes
Reference msg id not found: 200012042302.eB4N2MG55427@mail.postgresql.org | Resolved by subject fallback