Re: question about upper limit on TEXT size

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