Received: from PMESMTP01.wcom.com (pmesmtp01.wcom.com [199.249.20.1]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA40958 for ; Thu, 23 Dec 1999 15:53:55 -0500 (EST) (envelope-from rrothe@mindspring.com) Received: from CONVERSION-DAEMON by firewall.mcit.com (PMDF V5.2-32 #41714) id <0FN700G01OP0M8@firewall.mcit.com> for pgsql-interfaces@postgreSQL.org; Thu, 23 Dec 1999 20:53:24 +0000 (GMT) Received: from omzrelay.mcit.com ([166.37.204.49]) by firewall.mcit.com (PMDF V5.2-32 #41714) with ESMTP id <0FN700CG6OP0O6@firewall.mcit.com> for pgsql-interfaces@postgreSQL.org; Thu, 23 Dec 1999 20:53:24 +0000 (GMT) Received: from omzmta03.mcit.com (omzmta03.mcit.com [166.37.194.121]) by omzrelay.mcit.com (8.8.7/) with ESMTP id UAA29771 for ; Thu, 23 Dec 1999 20:53:27 +0000 (GMT) Received: from mindspring.com ([166.42.215.139]) by omzmta03.mcit.com (InterMail v03.02.05 118 121 101) with ESMTP id <19991223205323.NBVH15369@mindspring.com> for ; Thu, 23 Dec 1999 20:53:23 +0000 Date: Thu, 23 Dec 1999 15:51:28 -0500 From: Robert Rothe Subject: Always get TranBlock notice using 'c' To: "pgsql-interfaces@postgreSQL.org" Message-id: <38628B50.FF9F52B7@mindspring.com> MIME-version: 1.0 X-Mailer: Mozilla 4.61 [en] (Win95; I) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7bit X-Accept-Language: en All, When writing apps using 'c' and the preprocessor, I always get a "NOTICE: BeginTransactionBlock not in default state" with my first BEGIN statement. I've tried placing a COMMIT and END at the beginning of the app, but then I just get a NOTICE on the commit and another one on the BEGIN. This does not happen when using interactive pgsql. Is this addressed in an FAQ or can someone point me to the right place? Seems the app does not start in the default state. Thanks in advance, Rob