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

From Bruce Momjian
Subject Re: lo_import() of an empty file
Date
Msg-id 20180330183822.GR8476@momjian.us
Whole thread Raw
In response to Re: lo_import() of an empty file  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Fri, Mar 30, 2018 at 02:22:49PM -0400, Tom Lane wrote:
> 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.

Ah, yes, there is a row there.  Thanks.  No problem here.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +


pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: [HACKERS] AdvanceXLInsertBuffer vs. WAL segment compressibility
Next
From: "Bossart, Nathan"
Date:
Subject: Re: BUG #14941: Vacuum crashes