From: | Gražvydas Valeika <gvaleika(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Strange dump/restore effect |
Date: | 2012-09-23 21:37:31 |
Message-ID: | CAO6eJZrj-LsoqMiA=+Ys=uPuM+1KNUA6FyU2wEhOxfc2Vh2bhA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Ramsey | 2012-09-23 21:44:37 | Re: Strange dump/restore effect |
Previous Message | Raymond O'Donnell | 2012-09-23 20:45:33 | Re: Upgrade from 8.4.13 to 9.2.0.1 successful but it still displays 8.4.13 if SELECT version(); |