[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