pg_toast_xxxxxx_index is not a btree error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: <pgsql-admin@xxxxxxxxxxxxxx>
Subject: pg_toast_xxxxxx_index is not a btree error
From: "Subbiah, Stalin" <SSubbiah@xxxxxxxxxxx>
Date: Tue, 10 May 2005 11:05:10 -0700
Thread-index: AcVVis5Wt87KQ2kJQ9aAJVJyXRLB8g==
Thread-topic: pg_toast_xxxxxx_index is not a btree error

Title: pg_toast_xxxxxx_index is not a btree error

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

Follow-Ups:
- Re: pg_toast_xxxxxx_index is not a btree error
  - From: Tom Lane

Prev by Date: Extracting rowid of a locked row.
Next by Date: Re: pg_toast_xxxxxx_index is not a btree error
Previous by thread: Extracting rowid of a locked row.
Next by thread: Re: pg_toast_xxxxxx_index is not a btree error
Index(es):
- Date
- Thread

[Index of Archives] [KVM ARM] [KVM ia64] [KVM ppc] [Virtualization Tools] [Spice Development] [Libvirt] [Libvirt Users] [Linux USB Devel] [Linux Audio Users] [Yosemite Questions] [Linux Kernel] [Linux SCSI] [XFree86]

Powered by Linux