Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group