On Jan 2, 2009, at 10:26 AM, Sherief N. Farouk wrote: >> Preliminary documentation can be seen at >> http://www.sqlite.org/draft/lang_savepoint.html > > > Why savepoints? Why not just add support for named transactions? Is > there > some semantic difference I'm missing?
SAVEPOINTs is the way PostgreSQL and MySQL do it, as well as many other SQL database engines. We want to maximize compatibility. We have discussed letting you used named transactions using BEGIN. We might add that in the future. But for now, SAVEPOINT seems to be the safest way to do things - and the least likely to cause compatibility problems. > > > - Sherief > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
