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). That is all. Luca --------- Original Message -------- Da: Richard Huxton <dev@xxxxxxxxxxxx> To: Cc: pgsql-general@xxxxxxxxxxxxxx Oggetto: Re: POSIX and libpq Data: 11/12/07 21:31 > > > > luca.ciciriello@xxxxxxxx wrote: > >>> Does someone know if there is some kind of incompatibility between > > POSIX > >>> (glibc 2.4) and libpq (postgres 8.2) on Linux RedHat 5.0? > >> Do you really mean RedHat 5.0 - the one released in 1997? > > > Sorry, my information was not complete. > > The Linux version is Linux AS 5.0 Enterprise > > Seems unlikely that it wouldn't compile on RH's latest enterprise system. > > What problems are you encountering? > > -- > 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 > > > -- Email.it, the professional e-mail, gratis per te: http://www.email.it/f Sponsor: Fiorucci Pin-Up Collection: scopri le nuove fragranze e...vinci 1000 Euro di shopping in limousine! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=7262&d=20071212 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
