[EMAIL PROTECTED] 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
