X-Original-To: pgsql-interfaces@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 473D147634E
	for <pgsql-interfaces@postgresql.org>;
	Wed,  7 May 2003 17:49:01 -0400 (EDT)
Received: from hotmail.com (dav38.sea2.hotmail.com [207.68.164.95])
	by postgresql.org (Postfix) with ESMTP id 3A072475B8E
	for <pgsql-interfaces@postgresql.org>;
	Wed,  7 May 2003 17:49:00 -0400 (EDT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Wed, 7 May 2003 14:49:02 -0700
Received: from 159.119.44.232 by dav38.sea2.hotmail.com with DAV;
	Wed, 07 May 2003 21:49:01 +0000
X-Originating-IP: [159.119.44.232]
X-Originating-Email: [san_madhav@hotmail.com]
From: "sankar" <san_madhav@hotmail.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Using one connection object.
Date: Wed, 7 May 2003 14:46:10 -0700
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0023_01C314A7.6620B7A0"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
Message-ID: <Sea2-DAV38xSQWBLYu700000dc7@hotmail.com>
X-OriginalArrivalTime: 07 May 2003 21:49:02.0311 (UTC)
	FILETIME=[79154F70:01C314E2]
X-Spam-Status: No, hits=-0.9 required=5.0 tests=BAYES_30,HTML_30_40
	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200305/24
X-Sequence-Number: 4142

This is a multi-part message in MIME format.

------=_NextPart_000_0023_01C314A7.6620B7A0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I am using postgresql 7.2 on red hat linux.I am having only one connection =
to the database thro=20
PGconn(struct pg_conn ) which serves all the clients. I understand that PGc=
onn is not thread safe.
So from my program I am having mutexes to protect PGconn from multiple acce=
ss by 2 or more threads.

Using this model execution goes thro for around 20/30 queries. After that s=
omehow ExecTuplesOK() call from one thread is blocking for some reason beca=
use of which other threads are not able to proceed. (Pls note I have protec=
ted call to ExecTuplesOK()  using mutex so that only one  thread can enter =
it.)

If anybody has any idea pls let me know..

Thanks in advance
Sankarshana M
------=_NextPart_000_0023_01C314A7.6620B7A0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-1">
<META content=3D"MSHTML 6.00.2800.1106" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>I am using postgresql 7.2 on red hat linux=
.I am=20
having only one connection to the database thro </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>PGconn(struct pg_conn ) which serves all t=
he=20
clients. I understand that PGconn is not thread safe.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>So from my program I am having mutexes to =
protect=20
PGconn from multiple access by 2 or more threads.</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Using this model execution goes thro for a=
round=20
20/30 queries. After that&nbsp;</FONT><FONT face=3DArial size=3D2>somehow=
=20
ExecTuplesOK() call from one thread is blocking for some reason because of =
which=20
other threads are not able to proceed. (Pls note I have protected call to=
=20
ExecTuplesOK()&nbsp; using mutex so that only one&nbsp; thread can enter=20
it.)</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>If anybody has any idea pls let me=20
know..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanks in advance</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Sankarshana M</FONT></DIV></BODY></HTML>

------=_NextPart_000_0023_01C314A7.6620B7A0--