The following bug has been logged online:
Bug reference: 2962
Logged by: Gary Chambers
Email address: gwchamb(at)gmail(dot)com
PostgreSQL version: 8.2.1
Operating system: RHEL WS 4 (2.6.9-42.0.3.EL)
Description: 8.2.1 lo_creat Documentation incorrect?
Details:
8.2.1 documentation, section 30.4:
SELECT lo_creat(-1); -- returns OID of new, empty large object
The documentation states that a new, empty oid is returned if -1 is passed
to either lo_creat or lo_create.
This returns 2^32-1 on every invocation. Passing a zero seems to work
correctly, however.