CODEWITHSUNDEEP
pythondjangopostgresqlpsycopg2
gagangupt16
gagangupt16

Reputation: 231

Error while using inspectdb in Django

I already have an application using PostgreSQL as db. I want to build a service using Django. Tried "inspectdb"... but it is giving an expection:

Traceback (most recent call last):
 File "manage.py", line 10, in <module>
   execute_from_command_line(sys.argv)
 File "/usr/local/lib/python3.4/dist-packages/django/core/management/__init__.py", line 350, in execute_from_command_line
   utility.execute()
 File "/usr/local/lib/python3.4/dist-packages/django/core/management/__init__.py", line 342, in execute
   self.fetch_command(subcommand).run_from_argv(self.argv)
 File "/usr/local/lib/python3.4/dist-packages/django/core/management/base.py", line 348, in run_from_argv
   self.execute(*args, **cmd_options)
 File "/usr/local/lib/python3.4/dist-packages/django/core/management/base.py", line 399, in execute
   output = self.handle(*args, **options)
 File "/usr/local/lib/python3.4/dist-packages/django/core/management/commands/inspectdb.py", line 25, in handle
   for line in self.handle_inspection(options):
 File "/usr/local/lib/python3.4/dist-packages/django/core/management/commands/inspectdb.py", line 70, in handle_inspection
   constraints = connection.introspection.get_constraints(cursor, table_name)
 File "/usr/local/lib/python3.4/dist-packages/django/db/backends/postgresql/introspection.py", line 172, in get_constraints
   "foreign_key": tuple(used_cols[0].split(".", 1)) if kind.lower() == "foreign key" else None,
IndexError: list index out of range

Upvotes: 3

Views: 1307

Answers (1)

gagangupt16
gagangupt16

Reputation: 231

Figured out the issue.

Apparently, the db user didn't have sufficient permissions.

Upvotes: 3

Related Questions