Primary Key Indexing problem

From: John Brothers <johnbr(at)undefined(dot)com>
To: pgsql-general(at)postgresql(dot)org, thoth(at)incanta(dot)net
Subject: Primary Key Indexing problem
Date: 2000-01-18 12:20:00
Message-ID: 4.1.20000118071212.00c8a660@pop.mindspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

HI all,

I have a script which generates a simple table, fills it with
about 11000 unique numbers, in the primary key field,
and then at the end, shows that the index has been
lost for at least one of the values, allowing another
entry to be made that duplicates the index. This is an
abstract simplification of a problem we are experiencing in
our field database.

The compressed "script" is 64k - I didn't want to attach it to this
message, but I would be happy to send it to anyone who might
be able to use it to track down whatever bug(s) might be causing
it. (I am assuming that this is a bug. If not, please accept my
apologies).

[PostgreSQL 6.5.1 on i686-pc-linux-gnu, compiled by gcc 2.7.2.3]

Thanks,

John

------------
johnbr(at)incanta(dot)net

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jose Soares 2000-01-18 13:41:34 Re: [GENERAL] select for insert?
Previous Message Lincoln Yeoh 2000-01-18 08:13:26 Re: [GENERAL] select for insert?