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

BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem

From: "Michael Enke" <michael(dot)enke(at)wincor-nixdorf(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem
Date: 2006-07-25 16:06:19
Message-ID: 200607251606.k6PG6J35075382@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2550
Logged by:          Michael Enke
Email address:      michael(dot)enke(at)wincor-nixdorf(dot)com
PostgreSQL version: 8.1.4
Operating system:   SuSE Linux 9.2
Description:        pg_dumpall 7.4.13 -> restore 8.1.4 problem
Details: 

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.

The same for pg_group
Is there a way to patch the output of pg_dumpall 7.4?
I found nothing in the docu (heavy to look for,
pg_dumpall found in so many places).

Responses

pgsql-bugs by date

Next:From: Zuleima LaraDate: 2006-07-25 16:24:54
Subject: BUG #2551: to_char a to_number
Previous:From: Tom LaneDate: 2006-07-25 12:22:05
Subject: Re: BUG #2549: problem with NATURAL JOIN

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