Re: Re: pg_dump and LOs (another proposal) - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Re: pg_dump and LOs (another proposal)
Date
Msg-id Pine.LNX.4.21.0007062347420.4191-100000@localhost.localdomain
Whole thread Raw
In response to Re: Re: pg_dump and LOs (another proposal)  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
Philip Warner writes:

> >psql has \lo_import.

> This is true, but if there are 30000 blobs on an archive tape, I cant dump
> them into /tmp and wait for the user to run the script. At the current time
> pg_restore just sends a script to a file or stdout - it has no guarantee of
> when a \lo_import command will be run, so dumping blobs into the same file
> between lo_import calls would not be appropriate, since I am in effect
> requiring a psql attachment. 

I don't understand. How else would you restore a large object if not using
libpq's lo_import() call?


-- 
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: update on TOAST status'
Next
From: Peter Eisentraut
Date:
Subject: SQL float types