pg_toast_xxxxxx_index is not a btree error

From: "Subbiah, Stalin" <SSubbiah(at)netopia(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pg_toast_xxxxxx_index is not a btree error
Date: 2005-05-10 18:05:10
Message-ID: 6B26A56846293C4488B54CF3E4403354011BF181@mxca2.corp.netopia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2005-05-10 18:42:54 Re: pg_toast_xxxxxx_index is not a btree error
Previous Message users jtech softwares 2005-05-10 08:58:12 Extracting rowid of a locked row.