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