Subject: Re: DBD::Pg - UPDATEs, INSERTs fail to work
To: Cillian Sharkey <cns@RedBrick.dcu.ie>
From: Jaromir Dolecek <jdolecek@netbsd.org>
List: netbsd-help
Date: 09/23/2002 12:14:16
Cillian Sharkey wrote:
> I explicitly set AutoCommit to on (which is the default anyway) and even
> tried a manual commit() after the update, but that just prints a message
> that commits are ineffective when AutoCommit is enabled..
> 
> I guess I could try disabling AutoCommit and manually performing a commit,
> although I've never had this problem with DBI before! I'll let you know how
> that works. Thanks for the suggestion though.

Sorry, I noted that you have autocommit on after I sent the message.
What happens when you do UPDATE and SELECT in same session from the
script, do you see the change, or not?

Jaromir
-- 
Jaromir Dolecek <jdolecek@NetBSD.org>            http://www.NetBSD.org/
-=- We should be mindful of the potential goal, but as the tantric    -=-
-=- Buddhist masters say, ``You may notice during meditation that you -=-
-=- sometimes levitate or glow.   Do not let this distract you.''     -=-