title: Django with postgresql - manage.py syncdb returns errors
body: <p>I'm starting with Django. I had some site set up with SQLite working but after changing DB engine to postgresql manage.py syncdb returns errors.I've been googling for 2 days but still nothing works for me.Postgres user 'joe' has superuser rights and local 'joe' db exists. </p>
  
  <p>Postgresql is running:</p>
  
  <pre><code>/etc/init.d/postgresql status
  Running clusters: 9.1/main
  </code></pre>
  
  <p>Here's my part of settings.py</p>
  
  <pre><code>DATABASES = {
      'default': {
          'ENGINE': 'django.db.backends.postgresql_psycopg2',  #
          'NAME': 'joe',                                       # 
          'USER': 'joe',                                       # 
          'PASSWORD': 'asdf',                                  # 
          'HOST': 'localhost',                                 # 
          'PORT': '5432',                       .
      }
  }
  </code></pre>
  
  <p>And the errors:</p>
  
  <pre><code>$ python manage.py syncdb
  Syncing...
  Traceback (most recent call last):
    File "manage.py", line 11, in &lt;module&gt;
      execute_manager(settings)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 438, in execute_manager
      utility.execute()
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/__init__.py", line 379, in execute
      self.fetch_command(subcommand).run_from_argv(self.argv)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/base.py", line 191, in run_from_argv
      self.execute(*args, **options.__dict__)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute
      output = self.handle(*args, **options)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle
      return self.handle_noargs(**options)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/south/management/commands/syncdb.py", line 90, in handle_noargs
      syncdb.Command().execute(**options)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/base.py", line 220, in execute
      output = self.handle(*args, **options)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/base.py", line 351, in handle
      return self.handle_noargs(**options)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/core/management/commands/syncdb.py", line 59, in handle_noargs
      tables = connection.introspection.table_names()
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/db/backends/__init__.py", line 792, in table_names
      return self.get_table_list(cursor)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/db/backends/postgresql/introspection.py", line 31, in get_table_list
      AND pg_catalog.pg_table_is_visible(c.oid)""")
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/db/backends/util.py", line 34, in execute
      return self.cursor.execute(sql, params)
    File "/home/m/.virtualenvs/mayan/local/lib/python2.7/site-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute
      return self.cursor.execute(query, args)
  django.db.utils.DatabaseError: current transaction is aborted, commands ignored until end of transaction block
  </code></pre>
  
  <p>Thanks!</p>