pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / 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