Subject: Re: DBD::Pg - UPDATEs, INSERTs fail to work
To: Cillian Sharkey <cns@RedBrick.dcu.ie>
From: Jaromir Dolecek <email@example.com>
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 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.'' -=-