Postgres Pro
Downloads
Home   >   mailing lists

Re: lo_import() of an empty file - Mailing list pgsql-hackers

From Tom Lane
Subject Re: lo_import() of an empty file
Date
Msg-id 13129.1522434169@sss.pgh.pa.us
Whole thread Raw
In response to lo_import() of an empty file  (Bruce Momjian <bruce@momjian.us>)
Responses Re: lo_import() of an empty file  (Bruce Momjian <bruce@momjian.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <bruce@momjian.us> writes:
> I have just discovered if you try to lo_import() an empty file, and oid
> is returned, but nothing is added to pg_largeobject:

Why would you expect there to be?  There's no data to store.

There should be an entry in pg_largeobject_metadata, though.

            regards, tom lane

pgsql-hackers by date:

Previous
From: Nikhil Sontakke
Date:
Subject: Re: [HACKERS] logical decoding of two-phase transactions
Next
From: Stephen Frost
Date:
Subject: Re: [HACKERS] AdvanceXLInsertBuffer vs. WAL segment compressibility