Re: pg_dump failure, can't get data out...

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: pg_dump failure, can't get data out...
Дата
Msg-id Pine.LNX.4.30.0108270320070.699-100000@peter.localdomain
обсуждение исходный текст
Ответ на pg_dump failure, can't get data out...  (Larry Rosenman <ler@lerctr.org>)
Ответы Re: pg_dump failure, can't get data out...  (Larry Rosenman <ler@lerctr.org>)
Re: pg_dump failure, can't get data out...  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Larry Rosenman writes:

> pg_dump: query to get function name of oid - failed: ERROR:  oidin:
> error in "-": can't parse "-"

It's trying to dump a functional index but the function appears to be
absent.  (Therefore the name comes out as '-'.)  It's hard to tell which
index this is because the query pg_dump uses does not ORDER BY, but if in
doubt you can try the query in pg_dump.c:getIndexes() yourself -- it will
be the first index.  Offhand I don't see a related change in pg_dump in
recent times, so it probably isn't necessarily an upgrade related issue,
it might be an inconsistent schema.

It might be easiest to remove the index in question before dumping.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter



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

Предыдущее
От: Larry Rosenman
Дата:
Сообщение: Re: pg_dump failure, can't get data out...
Следующее
От: Hiroshi Inoue
Дата:
Сообщение: Re: linking hba.c