Re: Re: pg_dump and LOs (another proposal)

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Re: pg_dump and LOs (another proposal)
Дата
Msg-id Pine.LNX.4.21.0007062347420.4191-100000@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Re: pg_dump and LOs (another proposal)  (Philip Warner <pjw@rhyme.com.au>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: update on TOAST status'
Следующее
От: Peter Eisentraut
Дата:
Сообщение: SQL float types