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@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org]On Behalf Of Serge Canizares
Sent: Wednesday, December 20, 2000 12:18 AM
To: Rainer Mager
Cc: pgsql-admin@postgresql.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