[Zope-DB] Psycopg, Zope & Autocommit

Federico Di Gregorio fog@initd.org
10 Nov 2002 23:59:45 +0100


--=-nyDRR1h8wMgdBY4eQ380
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

Il dom, 2002-11-10 alle 23:40, Dieter Maurer ha scritto:
> Charlie Clark writes:
>  > ...
>  > I've just switched to=20
>  > PostgreSQL using psycopg and I didn't have to change anything in windo=
ws.=20
>  > Having just installed my application on a Linux server I find that non=
e of=20
>  > the methods are really being called unless I add "commit;" at the end =
of=20
>  > the method.
> Must be something strange:
>=20
>   I use PostgreSQL with "ZpsycopgDA/psycopg" on Linux and the
>   Z SQL Methods work without a trailing "commit".
>=20
>   Unless there are exceptions, they should be autocommited
>   by Zope's transaction machinery.
>   They do for me.

this is how it works and let me add that adding COMMIT at the end of
every SQL Method will badly confuse Zope's transaction machinery.

--=20
Federico Di Gregorio
Debian GNU/Linux Developer & Italian Press Contact        fog@debian.org
INIT.D Developer                                           fog@initd.org
     One key. One input. One enter. All right. -- An american consultant
           (then the system crashed and took down the *entire* network)

--=-nyDRR1h8wMgdBY4eQ380
Content-Type: application/pgp-signature; name=signature.asc

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQA9zuThvcCgrgZGjesRAuiwAKChDz1uP2GKy8IH4xF7MZfX2YpLuQCeKb3w
9PlTGS/pqERx8VSelCBF30E=
=fPsh
-----END PGP SIGNATURE-----

--=-nyDRR1h8wMgdBY4eQ380--