pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Anagha Joshi <ajoshi@nulinkinc.com>
To: pgsql-sql@postgresql.org
Subject: Seqno. is not btree?
Date: Mon, 30 Jun 2003 16:23:50 +0530
Message-ID: <FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com> (raw)

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

view thread (2+ messages)  latest in thread

Message-ID: <FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com>
Permalink:  ../FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com/
Also on:    postgresql.org/message-id/FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: ajoshi@nulinkinc.com
  Subject: Re: Seqno. is not btree?
  In-Reply-To: <FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com>
  References: <FF851C7EEB75954F9BCFB5CA117AB1EC092845@delta.nulinkinc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox