There may be implementation reasons for this, but try to see it from a
user's point of view. An error, to a user, means "something went wrong;
whatever you tried to do didn't work". If a message is harmless, it
should be, at best, a warning. From a more practical point of view, it's
not realist
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 J
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
>
Evan Martin wrote
> When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
> into a new, blank database it generates thousands of error messages like
> this:
>
> pg_restore: [archiver (db)] could not execute query: ERROR: schema
> "myschema" does not exist
> Command was:
I'm not sure I see the problem. The rule name is only unique within the
table, so it would not replace a rule on a different table (or view, as
is the case here) than the one being restored. Functions names should be
schema-qualified and if I'm restoring a function from a backup I would
want an
On 09/04/2013 07:02 AM, 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:
When I use pg_restore with --clean to restore a PostgreSQL 9.2.4database
into a new, blank database it generates thousands of error messages like
this:
pg_restore: [archiver (db)] could not execute query: ERROR: schema
"myschema" does not exist
Command was: DROP INDEX myschema.some_index
