Pb importing data in v. 7.0.3

Поиск
Список
Период
Сортировка
От Herve Piedvache
Тема Pb importing data in v. 7.0.3
Дата
Msg-id 92vfnm$or5$1@news.tht.net
обсуждение исходный текст
Ответы Re: Pb importing data in v. 7.0.3
Список pgsql-general
Hi,

I've got a problem when doing an import of data after a backup.

bkp cmd: pg_dump mydatabase > db

Then I dropped the base and recreate one.

When doing a "psql -e mydatabase < db", an error occured when recreating
indexes.

The error is :
-------------------------
FATAL 1:  btree: failed to add item to the page in _bt_sort (2)
pqReadData() -- backend closed the channel unexpectedly.
        This probably means the backend terminated abnormally
        before or while processing the request.
connection to server was lost
-------------------------

It seems to be because the lower index is > than the upper ...
The source code for this error is in :the file
"src/backend/access/nbtree/nbsort.c

I understood that this problem was existing in earlier version of Postgres,
like 6.5.*
Is there any solution to make my import of data working properly.

Thanks a lot for any help, and sorry for my poor english

--
Lifo.






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

Предыдущее
От: "Gregory Wood"
Дата:
Сообщение: > > > Then it goes right back to what someone else eluded to... If you
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: How to identify the class of a record