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
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? |