id summary reporter owner description type status priority milestone component version severity resolution keywords cc 5349 PostGIS delete layer failed bishop warmerdam "In ogrpgdatasource.cpp the OGRPGDataSource::DeleteLayer provide such commands to PostGIS {{{ BEGIN; DELETE FROM geometry_columns WHERE f_table_name='roads' and f_table_schema='public'; DROP TABLE ""public"".""roads"" CASCADE; COMMIT; }}} But execution produce an error: {{{ ERROR: cannot delete from view ""geometry_columns"" HINT: You need an unconditional ON DELETE DO INSTEAD rule or an INSTEAD OF DELETE trigger. ********** Error ********** ERROR: cannot delete from view ""geometry_columns"" You need an unconditional ON DELETE DO INSTEAD rule or an INSTEAD OF DELETE trigger. }}} As I see while deleting the PostGIS execute itself the trigger and ""DELETE FROM geometry_columns WHERE f_table_name='roads' and f_table_schema='public';"" not needed. Version: PostgreSQL 9.1.9 on amd64-portbld-freebsd8.3, compiled by cc (GCC) 4.2.1 20070831 patched [FreeBSD], 64-bit SELECT PostGIS_full_version(); ""POSTGIS=""2.0.0SVN"" GEOS=""3.3.1-CAPI-1.7.1"" PROJ=""Rel. 4.7.1, 23 September 2009"" LIBXML=""2.7.8"" USE_STATS"" I think the some PG version check is needed in OGRPGDataSource::DeleteLayer. The sample check is in attached patch." defect closed normal OGR_SF svn-trunk normal fixed PostGIS OGR DeleteLayer