Hi all,
I just migrated to 9.2 and observing stange thing.
While restoring 9.2 database to another server's empty database I'm getting several errors while restoring views:
pg_restore: creating RULE _RETURN
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 5466; 2618 26660 RULE _RETURN postgres
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near ")"
LINE 2: ALTER VIEW v_vehicle SET ();
^
Command was: CREATE RULE "_RETURN" AS ON SELECT TO v_vehicle DO INSTEAD SELECT v.vehicle_id, v.vehicle_code, v.home_location_id, v.vehicl...
pg_restore: creating RULE _RETURN
pg_restore: [archiver (db)] Error from TOC entry 5487; 2618 26835 RULE _RETURN postgres
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at or near ")"
LINE 2: ALTER VIEW v_r_delivery SET ();
There is lot of views, other are backuped/restored without problems.
Those several views which are restored with errors are visible in new database as empty tables.
Source database is produced by PostGIS 2.0 migration script from 9.1/PostGIS 1.5 database backup. Attempt to drop those strange views, recreate them and then run dump/restore doesn't change anything.
Same backup/restore procedure worked fine in 9.1.
Any ideas?
Grazvydas