pg_dump with postgis extension dumps rules separately - Mailing list pgsql-hackers

From Joe Conway
Subject pg_dump with postgis extension dumps rules separately
Date
Msg-id 5160B46D.2060904@joeconway.com
Whole thread Raw
Responses Re: pg_dump with postgis extension dumps rules separately
Re: pg_dump with postgis extension dumps rules separately
List 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



pgsql-hackers by date:

Previous
From: Jeff Janes
Date:
Subject: Process title for autovac
Next
From: Joe Conway
Date:
Subject: Re: pg_dump selectively ignores extension configuration tables