Problems migrating from SQLite to PostgreSQL

[jaredbownds]

After migrating from SQLite to PostgreSQL, it seems certain plugins are not compatible. Any help or advise on resolving this particular error would be appreciated.

==== How to Reproduce ====

While doing a GET operation on /ticket/1790, Trac issued an internal error.

''(please provide additional details here)''

Request parameters:
{{{
{'id': u'1790'}
}}}

User agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/36.0.1985.125 Safari/537.36

==== System Information ====
|| '''Trac''' || 1.0 ||
|| '''Trac''' || 1.0 ||
|| '''Babel''' || 0.9.6 ||
|| '''Genshi''' || 0.6 (without speedups) ||
|| '''GIT''' || 1.7.1 ||
|| '''mod_wsgi''' || 3.2 (WSGIProcessGroup trac-dev WSGIApplicationGroup trac-dev.agraquest.int|) ||
|| '''psycopg2''' || 2.0.13 ||
|| '''Python''' || 2.6.6 (r266:84292, Apr 11 2011, 15:50:32) [[br]] [GCC 4.4.4 20100726 (Red Hat 4.4.4-13)] ||
|| '''Python''' || 2.6.6 (r266:84292, Apr 11 2011, 15:50:32) [[br]] [GCC 4.4.4 20100726 (Red Hat 4.4.4-13)] ||
|| '''pytz''' || 2010h ||
|| '''pytz''' || 2010h ||
|| '''setuptools''' || 0.6c11 ||
|| '''setuptools''' || 0.6c11 ||
|| '''Subversion''' || 1.6.15 (r1038135) ||
|| '''jQuery''' || 1.7.2 ||

==== Enabled Plugins ====
|| '''AutocompleteUsers''' || 0.4.2dev ||
|| '''BlackMagicTicketTweaks''' || 0.12r1 ||
|| '''BreadCrumbsNav''' || 0.2 ||
|| '''ComponentDependencyPlugin''' || 0.1 ||
|| '''ContextChrome''' || 0.3 ||
|| '''graphviz''' || 0.7.7dev ||
|| '''ReadonlySignedTickets''' || N/A ||
|| '''ScreenshotPaste''' || 0.1.1 ||
|| '''TicketSidebarProvider''' || 0.0 ||
|| '''TicketValidator''' || 0.2dev ||
|| '''trac-MultiRepoSearchPlugin''' || 0.6 ||
|| '''trac-WorkflowNotificationPlugin''' || 0.5 ||
|| '''TracAccountManager''' || 0.4.3 ||
|| '''TracAnnouncer''' || 1.0dev ||
|| '''TracAttachmentNotifyPlugin''' || 1.0.1 ||
|| '''TracAutoWikify''' || 0.2dev ||
|| '''TracCustomFieldAdmin''' || 0.2.8-r12166 ||
|| '''TracDateField''' || 2.0.0dev-r12118 ||
|| '''TracDragDrop''' || 0.12.0.11 ||
|| '''TracHoursPlugin''' || 0.6.0dev ||
|| '''TracHtmlNotificationPlugin''' || 0.12.0.1 ||
|| '''TracMigratePlugin''' || 0.12.0.3 ||
|| '''TracReportManager''' || 0.1 ||
|| '''TracSubTicketsPlugin''' || 0.2.0.dev-20130908 ||

==== Python Traceback ====
{{{
Traceback (most recent call last):
File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py", line 497, in _dispatch_request
dispatcher.dispatch(req)
File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py", line 224, in dispatch
self._post_process_request(req, *resp)
File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/web/main.py", line 338, in _post_process_request
resp = f.post_process_request(req, *resp)
File "build/bdist.linux-x86_64/egg/tracsubtickets/web_ui.py", line 73, in post_process_request
children = self.get_children(ticket.id)
File "build/bdist.linux-x86_64/egg/tracsubtickets/web_ui.py", line 107, in get_children
(parent_id, ))
File "/usr/lib/python2.6/site-packages/Trac-1.0-py2.6.egg/trac/db/util.py", line 65, in execute
return self.cursor.execute(sql_escape_percent(sql), args)
ProgrammingError: relation "subtickets" does not exist
LINE 1: SELECT parent, child FROM subtickets WHERE parent=1790
^

}}}