#3266: Cant Upgrade Trac After Updating to 0.10-dev
----------------------------------+-----------------------------------------
Reporter: [EMAIL PROTECTED] | Owner: daniel
Type: defect | Status: reopened
Priority: low | Milestone: 0.10
Component: trac-admin | Version: devel
Severity: normal | Resolution:
Keywords: sqlite |
----------------------------------+-----------------------------------------
Comment (by cboos):
More painful, but nevertheless necessary, if we don't want
to remove the table explicitely:
{{{
>>> cnx = sqlite.Connection("test.db")
>>> cnx.execute("begin")
<pysqlite2.dbapi2.Cursor object at 0x00AEBC80>
>>> cnx.execute("CREATE TEMPORARY TABLE test ( x int )")
<pysqlite2.dbapi2.Cursor object at 0x00A3E860>
>>> cnx.commit()
>>> cnx.execute("CREATE TEMPORARY TABLE test ( x int )")
Traceback (most recent call last):
File "<stdin>", line 1, in ?
pysqlite2.dbapi2.OperationalError: table test already exists
}}}
That being said, it would probably be a lot simpler to
explicitely drop that `session_old` table rather than
to overcomplexify the upgrade code.
--
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
