Jaromir Dolecek <jdolecek@netbsd.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.

-- 
Cillian