title: First steps with PostgreSQL + Django + South
body: <p>Hi Stackoverflow people, </p>
  
  <p>In the past, I always developed my Django projects locally with sqlite as database platform. Now, I wanted to move to PostgreSQL to take advantage of GIS features, but the transition gives me huge grief.</p>
  
  <p>I have installed postgresql similar to this <a href="http://groups.google.com/group/geodjango/browse_thread/thread/eab02419c2890d34" rel="nofollow">post</a> and then followed the <a href="https://docs.djangoproject.com/en/dev/ref/contrib/gis/install/" rel="nofollow">GeoDjango description</a> for the creation of the database.</p>
  
  <p>Furthermore, I replaced the models class by</p>
  
  <pre><code>from django.contrib.gis.db import models
  </code></pre>
  
  <p>and add</p>
  
  <pre><code>geolocation = models.PointField(_('Geo Location'), 
                  geography=True, 
                  help_text=_('Geolocation with Longitude and Latitude'))
  
  objects = models.GeoManager()
  </code></pre>
  
  <p>Now, before diving deeper into the postgreSQL sphere, I wanted to test the model access through the Django Admin, and I encountered the first error.</p>
  
  <p>When I select the model (which i just modified as mentioned above) in the Admin, I get the following error:</p>
  
  <pre><code>**InternalError at /admin/remap/project/**
  current transaction is aborted, commands ignored until end of transaction block 
  </code></pre>
  
  <p>This error is connected with a wrong sql query, but I am surprised that the Django Admin creates wrong sql statements (used by million developers and it worked fine in the earlier sqlite config).</p>
  
  <p>When I check the django sql statement, I can see the entry for the PointField</p>
  
  <pre><code>"geolocation" geography(POINT,4326) NOT NULL,
  </code></pre>
  
  <p>but when I check <em>psql \d projects</em>, I can't see the change to the PointField (this is what should cause the error). Since I am using South, I executed </p>
  
  <pre><code>./manage.py schemamigration projects --initial
  ./manage.py migrate projects
  </code></pre>
  
  <p>but I get the message</p>
  
  <pre><code>Running migrations for projects:
  - Nothing to migrate.
  - Loading initial data for projects.
  </code></pre>
  
  <p><strong>How can I convince south / postgresql that there is something to migrate? 
  Do you see any other problem with the transition form SQLite to PostgreSQL?</strong></p>
  
  <p>Thank you for your answer &amp; help!</p>