Re: Spurious error messages from pg_restore

No version boundaries. I can reproduce this on 9.2.4 by backing up and
immediately restoring a new DB with PostGIS:

CREATE DATABASE test;
CREATE EXTENSION postgis; -- Version 2.1
pg_dump --format custom --file test.bak test
pg_restore --jobs 4 --dbname test test.bak

On 04.09.2013 23:31, David Johnston wrote:
> Evan Martin wrote
>> Also, even without --clean I get 3 errors:
>>
>> pg_restore: [archiver (db)] Error while PROCESSING TOC:
>> pg_restore: [archiver (db)] Error from TOC entry 6755; 2618 4417788 RULE
>> geometry_columns_delete em
>> 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;
>>
>> (and same for "geometry_columns_insert" and "geometry_columns_update")
> I should probably go read up on this but I thought the behavior of
> extensions was such that anything created from an extension is omitted from
> the traditional dump/restore process.
>
> Is this a within 9.2 dump/restore or are you crossing version boundaries
> somewhere?
>
> What was the original version of PostgreSQL when PostGIS was installed and
> how was it installed?
>
> David J.
>
>
>
> --
> View this message in context:
http://postgresql.1045698.n5.nabble.com/Spurious-error-messages-from-pg-restore-tp5769545p5769626.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>