Received: from ns.itd.sterling.com (ns.itd.sterling.com [192.124.9.5]) by hub.org (8.8.8/8.7.5) with SMTP id QAA08290 for ; Wed, 9 Sep 1998 16:30:15 -0400 (EDT) Received: ns.itd.sterling.com id AA29516; Wed, 9 Sep 1998 15:23:34 -0500 Received: from willie (willie.itd.sterling.com [199.4.254.237]) by Cyclone.itd.sterling.com (8.6.9/8.6.9) with SMTP id QAA09866 for ; Wed, 9 Sep 1998 16:29:11 -0500 Message-Id: <03a301bddc31$4b09bec0$edfe04c7@itd.sterling.com> Reply-To: "Chris Williams" From: "Chris Williams" To: Subject: Problem using libpsql.a Date: Wed, 9 Sep 1998 16:34:42 -0400 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3115.0 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3110.3 I have an application that forks of a process and is updating a table in my postgres database. When I have the parent process query that table to see how much has completed I get weird results. Sometimes it works, sometimes it core dumps, and sometimes I get back a NULL results structure. But if I type that same query into my psql window, I get back the correct results everytime. Currently I don't do any type of locking on any of the tables. My question is should I be doing some locking and why is the query using the psql command prompt working and my direct call in my C code isn't? Thanks!! --------- Chris Williams Sterling Software Rome, New York Phone: (315) 336-0500 Email: chris_d_williams@sterling.com