Re: difference between statements
Adrian Klaver <[email protected]>
| Newsgroups | gmane.comp.python.db.pysqlite.user |
|---|---|
| Message-ID | <[email protected]> |
On Thursday 29 March 2007 5:45 pm, Dennis Lee Bieber wrote: > > So... off-hand, it looks as if DDL statements (table creation, etc.) > which affects SQLite internal tables are immediately committed. But DML > statements affecting said created table are not auto-commit (I just > verified that an exception is raised if trying to select from a > non-existent table). > > If Python 2.5 included module has changed to be auto-commit, then > that would be a discrepancy in the module WRT the db-api2 specification, > and also a change from the prior behavior of the external module. You might want to take a look at section 5 of the usage-guide for an explanation of what is happening. http://initd.org/pub/software/pysqlite/doc/usage-guide.html -- Adrian Klaver [email protected]