Seqno. is not btree?

From: "Anagha Joshi" <ajoshi(at)nulinkinc(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Seqno. is not btree?
Date: 2003-06-30 10:53:50
Message-ID: FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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=# select count(*) from vchar;
count
-------
2568
(1 row)
test=# 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message scott.marlowe 2003-06-30 12:06:25 Re: need some help with a delete statement
Previous Message Abdul Wahab Dahalan 2003-06-30 08:29:17 select column from table