#3266: Cant Upgrade Trac After Updating to 0.10-dev
----------------------------------+-----------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: jonas
Type: defect | Status: new
Priority: low | Milestone: 0.10
Component: trac-admin | Version: devel
Severity: normal | Resolution:
Keywords: sqlite |
----------------------------------+-----------------------------------------
Changes (by jonas):
* owner: daniel => jonas
* status: reopened => new
Comment:
Yeah, I agree that using standard CREATE/DROP TABLE is probably the best
solution.
It's unfortunate that some databases like mysql (also currently true for
sqlite due to a misfeature in pysqlite2) automatically commits the
transaction before DDL statements making it impossible for us to make the
entire upgrade process atomic. This however should however not stop us
from trying since some databases like postgresql handles this just fine.
I'll remove the CREATE TEMP TABLE usage from the upgrade scripts.
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3266>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
