> > At the end of several bulk inserts the following statements get executed: > > > > begin > > update pom_c2996785 set p3=3268837857008 where p3=34804837857008 > > update pom_c2996795 set p3=3268837857008 where p3=34804837857008 > > update pom_c2996804 set p3=3268837857008 where p3=34804837857008 > > commit > > > > When I check the database the last update has not been executed. Manually > > executing it in psql does work. > > ... ergo, the bug is not in the backend, but in whatever non-psql client > software you are using. Since you haven't mentioned what that is, > further speculation is difficult ...
I managed to construct a sample script which also fails in psql. It seems to be the hash index. If I leave out the "create index" line or use btree instead everything works fine. I will use btree now :) Thank you for your help. Markus
pom1.log.gz
Description: GNU Zip compressed data
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
