Seqno. is not btree?

Поиск
Список
Период
Сортировка
Искать
От
Anagha Joshi
Тема
Seqno. is not btree?
Дата
Msg-id
FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com
Список
Дерево обсуждения
Seqno. is not btree? "Anagha Joshi" <ajoshi@nulinkinc.com>
Re: Seqno. is not btree? Tom Lane <tgl@sss.pgh.pa.us>

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

В списке pgsql-sql по дате отправления
От: Abdul Wahab Dahalan
Дата:
Сообщение: select column from table
От: Rudi Starcevic
Дата:
Сообщение: Bitwise operation
FAQ