large object dump-restore problem(bug?)

Поиск
Список
Период
Сортировка
От Risko Peter
Тема large object dump-restore problem(bug?)
Дата
Msg-id Pine.LNX.4.21.0204252237260.363-100000@pepehost.ike
обсуждение исходный текст
Ответы Re: large object dump-restore problem(bug?)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

  I am using postgresql 7.2.1-2 on Debian (woody). Everything is fine, but
it seems to me that lo dumping/restoring (or lo_import?) is buggy:

  -with psql I import some lo into the db:
vegzes=# \lo_import /pl.sh 'alma'
lo_import 16590
vegzes=# \lo_list
    Large objects
  ID   | Description
-------+-------------
 16590 | alma
(1 row)
  -It is okay, now I dump the db, in bash:
pg_dump -o -b -u -Ft vegzes >vegzes.dump
  -It's okay, now I drop and recreate the db (bash):
dropdb -U postgres vegzes
createdb -T template0 -U postgres vegzes
  -It's ok., let me restore it (bash):
pg_restore -v -u -d vegzes vegzes.dump
User name: postgres
pg_restore: connecting to database for restore
Password:
pg_restore: implied data-only restore
pg_restore: executing <Init> Max OID
pg_restore: disabling triggers
pg_restore: restoring data for table BLOBS
pg_restore: restoring large object OID 16590
pg_restore: connecting to database vegzes as user postgres
Password:
pg_restore: creating table for large object cross-references
pg_restore: restored 1 large objects
pg_restore: enabling triggers
pg_restore: disabling triggers
pg_restore: enabling triggers
  -It's okay, let me check the db (psql):
vegzes=# \lo_list
    Large objects
  ID   | Description
-------+-------------
 16600 |

  Here is my problem. The lo I restored has a new ID, and the description
vanished. Is there a solution for this?

thanks: Peter RISKO




В списке pgsql-general по дате отправления:

Предыдущее
От: "Joseph Artsimovich"
Дата:
Сообщение: bit datatype in 7.2.1
Следующее
От: Uros Gruber
Дата:
Сообщение: Re: Auth problem in pg_hdba.conf