[Pkg-postgresql-public] Bug#688960: Bug#688960: postgresql-common - pg_upgradecluster fails with "OLD used in query that is not in a rule"

[Peter Eisentraut]

On Thu, 2012-09-27 at 15:58 +0200, Bastian Blank wrote:
> Reason is the use of the pg_dumpall from 9.1, which does not work with
> the 8.4 server:
> | # sudo -u postgres /usr/lib/postgresql/9.1/bin/pg_dumpall -s > out
> | pg_dump: SQL command failed
> | pg_dump: Error message from server: ERROR:  OLD used in query that
> is not in a rule
> | LINE 1: LOCK TABLE old.eintraege IN ACCESS SHARE MODE
> |                    ^
> | pg_dump: The command was: LOCK TABLE old.eintraege IN ACCESS SHARE
> MODE
> | pg_dumpall: pg_dump failed on database "jsopac", exiting
> | # sudo -u postgres /usr/lib/postgresql/8.4/bin/pg_dumpall -s > out
> | # 

It is correct to use the pg_dumpall from 9.1 when upgrading from 8.4 to
9.1  What you see here is possibly an upstream bug in 9.1's
pg_dump(all).  Please send a reproducible test case to
pgsql-bugs at postgresql.org (e.g., execute this in 8.4 server, dump it
with 9.1 pg_dump, doesn't reload into 9.1 server).