From owner-freebsd-questions Tue May 7 13:34:31 2002 Delivered-To: freebsd-questions@freebsd.org Received: from blues.hodgsonhouse.com (blues.hodgsonhouse.com [24.72.10.211]) by hub.freebsd.org (Postfix) with ESMTP id C8B1A37B400 for ; Tue, 7 May 2002 13:34:24 -0700 (PDT) Received: (from tillman@localhost) by blues.hodgsonhouse.com (8.11.6/8.11.6) id g47KYNN20555 for freebsd-questions@FreeBSD.ORG; Tue, 7 May 2002 14:34:23 -0600 Date: Tue, 7 May 2002 14:34:23 -0600 From: Tillman Hodgson To: freebsd-questions@FreeBSD.ORG Subject: DBD-Pg Port & autocommit on FreeBSD Message-ID: <20020507143423.A20537@hodgsonhouse.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5.1i X-Editor: Vim Rocks! http://www.vim.org X-Mailer: Mutt Rocks! http://www.mutt.org Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk List-ID: List-Archive: (Web Archive) List-Help: (List Instructions) List-Subscribe: List-Unsubscribe: X-Loop: FreeBSD.ORG Howdy, It looks like I'm having trouble with INSERTs being automatically rolled back (I determined that by packet sniffing the database connection and seeing a "ROLLBACK" after each "INSERT"). The DBD::Pg documentation at http://www.perl.com/CPAN/modules/by-module/DBD/DBD-Pg-1.12.readme seems to imply that this is an issue with autocommit not working: "FreeBSD users: if you get during make test the error message: 'DBD driver has not implemented the AutoCommit attribute' recompile the DBI module and the DBD-Pg module and disable optimization. This error message is due to the broken optimization in gcc-2.7.2.1." I'm using port version 1.12. I don't need transaction support -- is there a way to confirm that the note in the DBD::Pg README file is relevent to the port or not, and if it is, is there a way to re-enable autocommit? - Tillman -- As long as your email program is sending mine ASCII text through an SMTP server [..] we're pretty much covered. (Some people believe in throwing in HTML support, which is a bit like using colored paper and glitter ink to improve your resume, but it takes all kinds.) - Rob Landley, linuxandmain.com To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message