=?UTF-8?Q?Gra=C5=BEvydas_Valeika?= <gvaleika@xxxxxxxxx> writes: > 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 (); > ^ Could you provide a self-contained example of a view that causes this? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general