Re: question about upper limit on TEXT size

Cindy <ctmoore(at)uci(dot)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