| From: | "Herve Piedvache" <herve(at)elma(dot)fr> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Pb importing data in v. 7.0.3 |
| Date: | 2001-01-03 15:14:46 |
| Message-ID: | 92vfnm$or5$1@news.tht.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-patches |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2001-01-03 16:02:55 | Re: How to identify the class of a record |
| Previous Message | Gregory Wood | 2001-01-03 15:05:06 | > > > Then it goes right back to what someone else eluded to... If you |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-03 16:52:13 | Re: Pb importing data in v. 7.0.3 |
| Previous Message | Tom Lane | 2001-01-02 07:47:31 | Re: [patch] src/include/storage/s_lock.h |