Subject: Re: DBD::Pg - UPDATEs, INSERTs fail to work
To: Jaromir Dolecek <email@example.com>
From: Cillian Sharkey <cns@RedBrick.dcu.ie>
Date: 09/23/2002 10:54:06
Jaromir Dolecek <firstname.lastname@example.org> wrote:
> You did COMMIT the update operation, didn't you? Note PostgreSQL is
> transactional db, so you do need to commit every operation otherwise
> it would be rolled back. psql might do implicit commit.
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.