Forum OpenACS Q&A: Response to Consequences of changing sec_session_properties.property_value to clob/blob

The corresponding field in PG is "text", which is in practice as large as  you would ever want it to be.

I've been wanting to visit this issue myself.  clob storage isn't the most efficient thing in the world ... we could pull the old trick of putting strings <= 4000K in length into the existing varchar and longer strings into a clob.  This would fix the APM problem (where you can't install all packages at once).  I don't know of any other place where this has been a problem, the table's really defined to be used for passing around small chunks of stuff.