Postgres Pro
Downloads
Home   >   mailing lists

pg_toast_xxxxxx_index is not a btree error - Mailing list pgsql-admin

From Subbiah, Stalin
Subject pg_toast_xxxxxx_index is not a btree error
Date
Msg-id 6B26A56846293C4488B54CF3E4403354011BF181@mxca2.corp.netopia.com
Whole thread Raw
Responses Re: pg_toast_xxxxxx_index is not a btree error  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view

Hi,

We are in process of upgrading one of our postgres database from 7.2.1 to 8.0.1. The dump was taken in copy format from 721 and imported the same into 801, but for some reason it fails in the middle of import with below error.

ERROR: index "tkt_cust_pkey" is not a btree
CONTEXT: COPY tkt_cust, line 1: "264363 Monika ..."
ERROR: index "pg_toast_1308103_index" is not a btree
CONTEXT: COPY tkt_acty, line 14318: "265337 6 conversation_chat_host
Any ideas why this happens ?
Thanks,
Stalin

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Concurrency
Next
From: Tom Lane
Date:
Subject: Re: pg_toast_xxxxxx_index is not a btree error