Update of wrong coloum???

Hi All

System: Red Hat 4.2, kernel 2.0.35, flex 2.5.4

For a couple of weeks now I have been having a problem..., I finally
nerrowed it down to this:

shell_connection=> update dllocation set selt = 'f';
ERROR: Cannot insert a duplicate key into a unique index
shell_connection=> \d dllocation

Table = dllocation
+------------------------------+--------------------------------+-------+
| Field | Type | Length|
+------------------------------+--------------------------------+-------+
| location | char() not null | 20 |
| selt | bool not null default 'f' | 1 |
+------------------------------+--------------------------------+-------+
Index: dl_location
shell_connection=>

The index dl_location is unique, btree.
There is no index on selt ( selt == selected )
There is less then a 1000 rows in the table, about 600 I think.

The results of the above update are NOT consistant, some times I get the
above error, some times it works, some times I get told that the backend
crashed.

The version I am running is a snap shot from 2? days ago, but have been
having the problem with older snap shots for the last week+.

Also, the part of my PHP 3 script that uses the above query is also new,
with a new feature I added about 2 weeks ago.

As you can see, the above query was run by hand in psql, so the problem is
not PHP or the PHP script.

As a side not, PostgreSQL built fine, and passed all regression tests,
even random.

Thanks, have a great night
Terry Mackintosh <terry(at)terrym(dot)com> http://www.terrym.com
sysadmin/owner Please! No MIME encoded or HTML mail, unless needed.

Proudly powered by R H Linux 4.2, Apache 1.3, PHP 3, PostgreSQL 6.3
-------------------------------------------------------------------
Success Is A Choice ... book by Rick Patino, get it, read it!