Philip Warner <pjw(at)rhyme(dot)com(dot)au> writes:
> This is for pg_dump which, when restoring BLOBs, inserts multiple rows into
> a temporary xref table. The sequence of events is:
> Conn1: Begin
> Conn1: lo_create/lo_close/lo_write.../lo_close
> Conn2: Insert into xref table (which does an implicit begin/end, I think).
> Conn1: Commit;
Two connections? Why in the world are you doing it like that --- and
especially in that order? Seems like this is committing an xref change
before the LO itself is committed. Why?
regards, tom lane