Re: [BUGS] Bug: Inserting

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: kimmo@lahdensi.vu
Cc: pgsql-bugs@postgresql.org, kimmol@tulppaani.com
Date: 1999-12-17T17:00:35Z
Lists: pgsql-bugs
kimmol@duniversum.com (Kimmo Lahdensivu) writes:
> There was one common thing to all the situations I was unable to insert.
> They were made using postgresql library of php3 (3.0.9). There were no
> error messages or anything but the data just didn't appear in the db.

I think PHP is one of the interfaces that has "autocommit" control (a
seriously misnamed feature IMHO).  What this really means is that your
changes *don't* get committed until you say so, because the interface
library issues a BEGIN WORK behind-your-back.  If you disconnect without
having done the correct incantation to cause a COMMIT, presto: all your
work is rolled back.

I don't know PHP well enough to know the magic incantation, however...

			regards, tom lane