Horton

Re: Binary large object processing problems

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Raivo Rebane <raivore55@gmail.com>
Cc: Christoph Moench-Tegeder <cmt@burggraben.net>, pgsql-general@postgresql.org
Date: 2023-03-13T16:18:27Z
Lists: pgsql-general 
Raivo Rebane <raivore55@gmail.com> writes:
> Thank for answer, but I was also readed this manual and found there :
> 35.3.2. Importing a Large Object

You need to read the start of that section, which says

    All large object manipulation using these functions
    <emphasis>must</emphasis> take place within an SQL transaction block,

As Christoph said, you're responsible for supplying a BEGIN and COMMIT
around the call.

			regards, tom lane