RE: SQL statement limit

I was unclear on this, although I think the answer below is correct for my
real question. Let me ask this question again...

What is the current size limit for a single row (say for type TEXT or
VARCHAR)? When is this expected to go away (7.1?)?

Is the info below accurate? Am I limited to 32k (if I rebuild)?

Thanks,

--Rainer

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org]On Behalf Of Serge Canizares
Sent: Wednesday, December 20, 2000 12:18 AM
To: Rainer Mager
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] SQL statement limit

If I understand your question, you can change this limit, but not to 200k.

By default, the data limit in a field record is 8k in the PostgreSQL 7.0x
series.
You can make it 16k or 32k.

Go into the src/include subdir of whatever directory you extracted the
tarball into.

Before compiling, edit the file called "config.h.in".
Change the line from

#define BLCKSZ 8192

to

#define BLCKSZ 32768

(for 32k limit).

-Serge