Re: BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Michael Enke" <michael(dot)enke(at)wincor-nixdorf(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem
Date: 2006-07-26 15:09:41
Message-ID: 2049.1153926581@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Michael Enke" <michael(dot)enke(at)wincor-nixdorf(dot)com> writes:
> I used pg_dumpall in 7.4.13.
> In the created backup there is a
> ... delete from pg_shadow ...
> since it is a table, all ok.

> But in 8.1.4 it is a view so I get an error at restore:
> ERROR: cannot delete from a view
> HINT: You need an unconditional ON DELETE DO INSTEAD rule.

Just ignore the error.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Phil Frost 2006-07-27 16:30:04 server stopped running abnormally
Previous Message Boris 2006-07-26 11:15:49 BUG #2552: wrong sql dump?