Strange dump/restore effect

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

Responses

Browse pgsql-general by date

  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();