Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 26 Jul 2006 11:09:41 -0400
"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
- References:
- BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem
- From: Michael Enke
- BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem
- Prev by Date: BUG #2552: wrong sql dump?
- Next by Date: server stopped running abnormally
- Previous by thread: BUG #2550: pg_dumpall 7.4.13 -> restore 8.1.4 problem
- Next by thread: BUG #2551: to_char a to_number
- Indexes: