pg_dump with postgis extension dumps rules separately

From: Joe Conway <mail(at)joeconway(dot)com>
To: postgres hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_dump with postgis extension dumps rules separately
Date: 2013-04-06 23:49:01
Message-ID: 5160B46D.2060904@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

If I create a database and install postgis as an extension, and then run
pg_dump I get this:

[...]
CREATE EXTENSION IF NOT EXISTS postgis WITH SCHEMA public;
[...]
CREATE RULE geometry_columns_delete AS ON DELETE TO geometry_columns DO
INSTEAD NOTHING;
[...]

Shouldn't that CREATE RULE be implicitly part of the CREATE EXTENSION?

If so, is this a pg_dump bug, PostGIS bug, or pilot error?

FWIW I see CREATE OR REPLACE RULE statements in the PostGIS extension
SQL script.

Thanks,

Joe

--
Joe Conway
credativ LLC: http://www.credativ.us
Linux, PostgreSQL, and general Open Source
Training, Service, Consulting, & 24x7 Support

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2013-04-06 23:49:35 Re: pg_dump selectively ignores extension configuration tables
Previous Message Alvaro Herrera 2013-04-06 21:10:49 Re: Process title for autovac