Re: question about upper limit on TEXT size - Mailing list pgsql-general

From Tom Lane
Subject Re: question about upper limit on TEXT size
Date
Msg-id 1575.1029275322@sss.pgh.pa.us
Whole thread Raw
In response to Re: question about upper limit on TEXT size  (Cindy <ctmoore@uci.edu>)
List pgsql-general
Cindy <ctmoore@uci.edu> writes:
> 7.2, on Solaris:

>>> on this column?  Could we see the output of
>>> select * from pg_class where relname = 'searches';

>  relname  | reltype | relowner | relam | relpages | reltuples | rellongrelid | r
> elhasindex | relisshared | relkind | relnatts | relchecks | reltriggers | reluke
> ys | relfkeys | relrefs | relhaspkey | relhasrules |      relacl

Um, well, I wasn't expecting to see the answer in the column headers...
but if that's the schema of pg_class then you are *not* talking to a 7.2
server.  It's evidently 7.0.something.  Try "select version()" to
find out for sure.  But in any case, you need a server update ---
pre-7.1 Postgres didn't have support for rows wider than 8K.

            regards, tom lane

pgsql-general by date:

Previous
From: Cindy
Date:
Subject: Re: question about upper limit on TEXT size
Next
From: Bruce Momjian
Date:
Subject: Press reporter looking for large installs