Re: Re: Silent failure of an INSERT
Karsten Hilbert <[email protected]> Fri, 23 Apr 2004 09:58:22 +0200
| Newsgroups | gmane.comp.python.db.pypgsql.user |
|---|---|
| Message-ID | <[email protected]> |
> > Sounds like you are missing a commit somewhere. > > I never did a BEGIN, so my understanding is that a COMMIT should not be > necessary. Depends on what your pyPgSQL does and what your PostgreSQL version is. pyPgSQL likely opens a transaction for you. PostgreSQL changed the default of auto-commit somewhere around 7.3 or so. Karsten -- GPG key ID E4071346 @ wwwkeys.pgp.net E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346 ------------------------------------------------------- This SF.net email is sponsored by: The Robotic Monkeys at ThinkGeek For a limited time only, get FREE Ground shipping on all orders of $35 or more. Hurry up and shop folks, this offer expires April 30th! http://www.thinkgeek.com/freeshipping/?cpg=12297