luca.ciciriello@xxxxxxxx wrote:
I've a multithread application running on Linux. In each thread i've a loop performing a single INSERT operation on the DB. Sometimes (not always), two of the three thread die apparently without any reason. The strange thing is that if I remove the store operation from the threads, all runs fine. Viceversa, if I run the INSERT loops out of the threads all runs the DB operation are executed without any problems. On Linux I'm super user and I create the three thread using the posix function pthread_create. The same code, on windows, doesn't present any problem (in windows I use CreateThread function).
It's almost certainly a threading problem. Have you read the relevant section of the manuals?
http://www.postgresql.org/docs/8.2/static/libpq-threading.html -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
