imposm error

gistfile1.txt

bin/imposm --overwrite-cache --read --write -d osm ~/osm_data/slo.california.osm 
Enabling Shapely speedups.
[10:53:11] ## reading /Users/sloale/osm_data/slo.california.osm
[10:53:11] coords: 1427k nodes: 28k ways: 203k relations: 1k (estimated)
[10:53:25] coords: 1437k nodes: 0k ways: 66k relations: 0k
[10:53:25] reading took 14s
[10:53:25] ## dropping/creating tables
[10:53:25] ## writing data
Traceback (most recent call last):
  File "bin/imposm", line 8, in <module>
    load_entry_point('imposm==2.3.2', 'console_scripts', 'imposm')()
  File "/Users/sloale/vimposm/lib/python2.7/site-packages/imposm/app.py", line 232, in main
    db.create_views(mappings, ignore_errors=True)
  File "/Users/sloale/vimposm/lib/python2.7/site-packages/imposm/db/postgis.py", line 234, in create_views
    PostGISUnionView(self, mapping).create(ignore_errors=ignore_errors)
  File "/Users/sloale/vimposm/lib/python2.7/site-packages/imposm/db/postgis.py", line 322, in create
    cur.execute('DELETE FROM geometry_columns WHERE f_table_name = %s', (self.view_name, ))
psycopg2.NotSupportedError: cannot delete from a view
HINT:  You need an unconditional ON DELETE DO INSTEAD rule.

I just imported the Boston area planet (from .pbf) with imposm and didn't see that error (PostgreSQL 9.0.4 + psycopg2 2.4.2). I assume your psycopg2 is working with other projects, correct? I had troubles getting it to work again after my lion upgrade. A rebuild with ARCHFLAGS="-arch i386 –arch x86_64" fixed my issues...

i can build psycopg2 with the proper arch flags via this post http://stackoverflow.com/questions/6854451/how-to-install-psycopg2-on-clean-os-x-lion-with-xcode-4-1/7295672#7295672 but i'm still getting the error above when i pass the imposm command. Thanks for the reply and tip about the flags. psycopg2 is indeed working with other projects...will keep looking around

You are running PostGIS 2? The geometry_columns table is read-only since 2.0, but Imposm manipulates it for the --deploy-production-tables feature. You need to downgrade to PostGIS 1.5 for now.

ahh - thanks Oliver! will close bitbucket ticket.