[dev] TEXT vs. BLOB in postgres for VFS?

Chuck Hagenbuch chuck at horde.org
Fri Oct 31 00:09:50 UTC 2008


Quoting Jan Schneider <jan at horde.org>:

> I can't say anything about historic blob support in PostgreSQL  
> itself though. but the most resource effective solution would  
> probably be to use the pg_lo PHP functions.
>
> This would require some flag though, since the data is incompatible.

That sounds like a reasonable approach to me (probably have it set to  
longblob by default, for new installs, with a note in docs/UPGRADING  
on how to preserve the old behavior). And change the .sql file of  
course.

-chuck


More information about the dev mailing list