Subject: Re: DBD::Pg - UPDATEs, INSERTs fail to work
To: Jaromir Dolecek <>
From: Cillian Sharkey <>
List: tech-pkg
Date: 09/23/2002 10:54:06
Jaromir Dolecek <> 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.