id	summary	reporter	owner	description	type	status	component	version	severity	resolution	keywords	cc	stage	has_patch	needs_docs	needs_tests	needs_better_patch	easy	ui_ux
2591	manage.py inspectdb causes exception on postgresql_psycopg2 backend	markus@…	Adrian Holovaty	"running ...
{{{
manage.py inspectdb 
}}}
cause an exception on postgresql_psycopg2 backend (might be the same to postgresql).

{{{
class AuthMessage(models.Model):
Traceback (most recent call last):
  File ""F:\...\manage.py"", line 11, in ?
    execute_manager(settings)
  ....
  File ""F:\...site-packages\django\core\management.py"", line 718, in inspectdb
    relations = introspection_module.get_relations(cursor, table_name)
  File ""F:\...site-packages\django\db\backends\postgresql_psycopg2\introspection.py"", line 36, in get_relations
    relations[int(row[0][1:-1]) - 1] = (int(row[1][1:-1]) - 1, row[2])
TypeError: int() argument must be a string or a number
}}}

I fixed this bug by editing line 36 from
{{{
introspection.py:36:   relations[int(row[0][1:-1]) - 1] = (int(row[1][1:-1]) - 1, row[2])
}}}
to ..
{{{
introspection.py:36:   relations[int(row[0][0]) - 1] = (int(row[1][0]) - 1, row[2])
}}}

I'am not familiarly with django but it seems to work.

"	defect	closed	django-admin.py inspectdb	dev	blocker	fixed		listuser@…	Ready for checkin	1	0	0	0	0	0