Re: Binary large object processing problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Raivo Rebane <raivore55(at)gmail(dot)com>
Cc: Christoph Moench-Tegeder <cmt(at)burggraben(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Binary large object processing problems
Date: 2023-03-13 16:18:27
Message-ID: 1885980.1678724307@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Raivo Rebane <raivore55(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Harrison Borges 2023-03-13 16:24:10 Issues Scaling Postgres Concurrency
Previous Message Raivo Rebane 2023-03-13 15:54:04 Re: Binary large object processing problems