Markus Mehrwald <[EMAIL PROTECTED]> writes:
> I tried to insert an image in my database with lo_import. The error I
> get is "invalid large object descriptor: 0".
lo_import has to be called within a transaction block (BEGIN/COMMIT).
The documentation is not very clear about that :-(
(Actually, rather than fix the documentation we probably ought to fix
the code --- there's enough infrastructure in libpq now that it could
tell whether it needs to start its own transaction or not.)
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general