Re: question about upper limit on TEXT size

Tom Lane writes:
 >Cindy <ctmoore@uci.edu> writes:

 >> 7.2, on Solaris:
 >
 >Hmph --- that certainly shouldn't have any trouble with a measly 50K
 >text value.

My thought, too :*)

 >I wonder if you've somehow managed to turn off TOASTing
 >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
----------+---------+----------+-------+----------+-----------+--------------+--
-----------+-------------+---------+----------+-----------+-------------+-------
---+----------+---------+------------+-------------+-------------------
 searches |       0 |     3895 |     0 |       10 |      1000 |            0 | t
           | f           | r       |        8 |         0 |           0 |
 0 |        0 |       0 | f          | f           | {"=","wwwd=arwR"}
(1 row)

(sorry for the poor formatting...that's pretty much how it appears
on my terminal)

 >and also the output of
 >    select attname,attstorage from pg_attribute where attrelid =
 >    (select oid from pg_class where relname = 'searches');


     attname      | attstorage
------------------+------------
 cmax             | p
 cmin             | p
 ctid             | p
 date_lastupdated | p
 date_saved       | p
 id               | p
 oid              | p
 parameters       | p
 search_name      | p
 search_type      | p
 temporary        | p
 uid              | p
 xmax             | p
 xmin             | p
(14 rows)

 >Do you see the same failure if you try to INSERT the data into
 >a freshly-created table, using the exact CREATE TABLE command you
 >just showed us?

That's exactly what I did prior to sending out mail to the list...I dropped
the table and re-created it.

--Cindy
--
ctmoore@uci.edu