X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 14AEB310846 for ; Mon, 30 Jun 2003 10:54:35 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 69960-04 for ; Mon, 30 Jun 2003 07:54:24 -0300 (ADT) Received: from TactiCom-MA1.TactiCom.com (unknown [216.235.244.20]) by svr1.postgresql.org (Postfix) with SMTP id 37818310945 for ; Mon, 30 Jun 2003 07:54:24 -0300 (ADT) Received: from [203.124.133.194] by TactiCom-MA1.Nulinkinc.com (NTMail 4.30.0013/NU4135.00.d4f82e0c) with ESMTP id idkiiaaa for ; Mon, 30 Jun 2003 06:53:52 -0400 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C33EF5.E3EB8074" Subject: Seqno. is not btree? X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 Date: Mon, 30 Jun 2003 16:23:50 +0530 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Seqno. is not btree? Thread-Index: AcM+9Yu08D6FUKrhEdedpgBABabtaA== From: "Anagha Joshi" To: X-Spam-Status: No, hits=1.8 tagged_above=0.0 required=5.0 tests=BAYES_20, HTML_60_70, RCVD_IN_DSBL X-Spam-Level: ** X-Archive-Number: 200306/332 X-Sequence-Number: 14090 This is a multi-part message in MIME format. ------_=_NextPart_001_01C33EF5.E3EB8074 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Hi, I use Postgresql-7.2.4 I've created following table: create table vchar ( seqno SERIAL, col_var character varying (8192) ); After as many as 2412081 records are inserted, I shutdown my server. My every record was inserted programatically by : insert into vchar (col_var) values ('VVV')......(VVV' char sequence was 8192 times long. i.e. in one row 8192 V's are present.) Next day,I tried the following: test=3D# select count(*) from vchar; count ------- 2568 (1 row) test=3D# insert into vchar (col_var) values ('VV'); ERROR: Index vchar_seqno_key is not a btree What does this error mean? My server log shows 2412081 records inserted but actual count(*) shows only 2568 records. Pls. help. Thx., Anagha ------_=_NextPart_001_01C33EF5.E3EB8074 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Seqno. is not btree?

Hi,

I use Po= stgresql-7.2.4

I’= ve created following table:

create t= able vchar (

 &n= bsp;  seqno SERIAL,

 &n= bsp;  col_var character varying (8192)

 &n= bsp;  );

After as= many as 2412081 records are inserted,&= nbsp; I shutdown my server.  My every record was ins= erted programatically by :

inser= t into vchar (col_var) values (‘VVV’)R= 30;…(VVV’ char sequence was= 8192 times long. i.e. in one row 8192 V’= s are present.)

Next day= ,I tried the following:

test=3D#= select count(*) from vchar;

 co= unt

-------<= /FONT>

  2= 568

(1 row)<= /FONT>

test=3D#= insert into vchar (col_var) values ('VV’);<= /SPAN>

ERROR= :  Index vchar_seqno_key is not a btree

What doe= s this error mean? My server log shows 2412081 records inserted but actual count(*) shows only 2568 records.

Pls. hel= p.

Thx.,

Anagha


------_=_NextPart_001_01C33EF5.E3EB8074--