[postgis-tickets] [PostGIS] #2223: Rules on geometry_columns make noisy backup/restore

[PostGIS]

#2223: Rules on geometry_columns make noisy backup/restore
-----------------------------------+----------------------------------------
 Reporter:  pramsey                |       Owner:  robe         
     Type:  defect                 |      Status:  new          
 Priority:  medium                 |   Milestone:  PostGIS 2.0.4
Component:  build/upgrade/install  |     Version:  2.0.x        
 Keywords:  rules                  |  
-----------------------------------+----------------------------------------
 On an ordinary database, using CREATE EXTENSION to enable PostGIS, and
 dumping using pg_dump as follows
 {{{
 pg_dump --file=nyc.backup --format=c --port=54321 --username=postgres nyc
 createdb -p 54321 nyc2
 pg_restore --dbname=nyc2 --port 54321 --username=postgres nyc.backup
 }}}
 The restore generates the following errors
 {{{
 pg_restore: [archiver (db)] Error while PROCESSING TOC:
 pg_restore: [archiver (db)] Error from TOC entry 3249; 2618 19424 RULE
 geometry_columns_delete postgres
 pg_restore: [archiver (db)] could not execute query: ERROR:  rule
 "geometry_columns_delete" for relation "geometry_columns" already exists
     Command was: CREATE RULE geometry_columns_delete AS ON DELETE TO
 geometry_columns DO INSTEAD NOTHING;

 pg_restore: [archiver (db)] Error from TOC entry 3247; 2618 19422 RULE
 geometry_columns_insert postgres
 pg_restore: [archiver (db)] could not execute query: ERROR:  rule
 "geometry_columns_insert" for relation "geometry_columns" already exists
     Command was: CREATE RULE geometry_columns_insert AS ON INSERT TO
 geometry_columns DO INSTEAD NOTHING;

 pg_restore: [archiver (db)] Error from TOC entry 3248; 2618 19423 RULE
 geometry_columns_update postgres
 pg_restore: [archiver (db)] could not execute query: ERROR:  rule
 "geometry_columns_update" for relation "geometry_columns" already exists
     Command was: CREATE RULE geometry_columns_update AS ON UPDATE TO
 geometry_columns DO INSTEAD NOTHING;
 }}}
 This is unfortunate, since our dump/restore story is now supposed to be
 pristine in the new world of extensions.

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/2223>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.