POSIX and libpq

luca.ciciriello@email.it wrote:

Hi list.

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?

--
Richard Huxton
Archonet Ltd

Sorry, my information was not complete.
The Linux version is Linux AS 5.0 Enterprise

Luca

--------- Original Message --------
Da: Richard Huxton <dev@archonet.com>
To:
Cc: pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] POSIX and libpq
Data: 11/12/07 19:36

luca.ciciriello@email.it wrote:

Hi list.

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?

--
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:
Fai squillare la PANTERA ROSA sul tuo cellulare: e' in REGALO
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=6613&amp;d=20071211

luca.ciciriello@email.it 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

Richard Huxton <dev@archonet.com> writes:

luca.ciciriello@email.it 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?

Something fishy here though, because RHEL5 ships glibc-2.5 not 2.4,
if I'm reading Red Hat's CVS correctly.

I wonder whether Luca is trying to use a libpq.so that was compiled on
some other Linux release with a different glibc version.

regards, tom lane

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@archonet.com>
To:
Cc: pgsql-general@postgresql.org
Oggetto: Re: [GENERAL] POSIX and libpq
Data: 11/12/07 21:31

luca.ciciriello@email.it 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&amp;d=20071212

luca.ciciriello@email.it 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