The following bug has been logged online: Bug reference: 2550 Logged by: Michael Enke Email address: [EMAIL PROTECTED] 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). ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
