Hi all,
PostgreSQL 9.3 has support for 2GB+ large object support via
new APIs. e.g. lo_lseek64(), lo_tell64()
I've made patch that supports new 64bit large object APIs.
https://gist.github.com/yohgaki/35b12a48ac6332633e60
It adds new functions pg_lo_seek64(), pg_lo_tell64, pg_lo_truncate64().
However, these new functions are not mandatory. It could be made to use
php.ini setting which specifies libpq API is used by
pg_lo_seek()/pg_lo_tell()/
pg_lo_truncate().
libpq's lo_lseek(), lo_tell() will be legacy and unused APIs in the long
run.
Therefore, it may be better to change API to be used according to php.ini
setting. e.g. When pgsql.server_version=9.3 (or greater), use lo_*64()
if it's available.
Pros.
- No additional API exposed.
- No legacy API in the future.
- Old code can extend capability w/o code change.
- No additional user code is required to detect and switch API.
- No query is required to detect PostgreSQL server version when
php.ini based switch is used.
Cons.
- Additional php.ini that specifies server version.
Even though I've made patch that simply exposes new libpq APIs,
patch that has php.ini switch is better. IMO.
Any comments?
If there aren't any objections, I'll create and commit patch that uses
php.ini to change pg_lo_*() behavior.
Note about libpq's lo_*64() APIs:
These APIs returns -1(failure) always if server version is less than
PostgreSQL 9.3.
Note for 32bit platforms:
Since PHP int is 32bit int, 64bit support could be used but it's limited
by 32bit int.
Regards,
--
Yasuo Ohgaki
yohgaki@ohgaki.net