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
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).
pgsql-bugs by date
|Next:||From: Zuleima Lara||Date: 2006-07-25 16:24:54|
|Subject: BUG #2551: to_char a to_number|
|Previous:||From: Tom Lane||Date: 2006-07-25 12:22:05|
|Subject: Re: BUG #2549: problem with NATURAL JOIN |