Andres Freund <and...@2ndquadrant.com> writes: >> pg_restore: [archiver (db)] Error from TOC entry 3874; 2618 396850 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; >> >> This happens because in the beginning of backup file there is issued >> command >> CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public; >> which creates those rules. > >> As I understand these errors are harmless, I would say - cosmetic defects. > > I'd say this is actually a real bug in the extensions tracking of > dependencies. > And it would have caused a failed restore if you had used single > transaction mode.
Indeed. I will look into that. Regards, -- Dimitri Fontaine http://2ndQuadrant.fr PostgreSQL : Expertise, Formation et Support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
