small pg_dumpall bug/warning in 8.1beta1

Started by Stefan Kaltenbrunnerover 20 years ago3 messages
#1Stefan Kaltenbrunner
stefan@kaltenbrunner.cc

Hi!

During testing of 8.1 I found that using pg_dumpall (-g) against a live
8.0 install that has at least one GROUP defined results in the following
warning while it creates the CREATE ROLE statements in the dump:

row number 0 is out of range 0..-1

To reproduce the problem it is enough to init a new 8.0 cluster, create
a empty GROUP and dump the cluster using pg_dumpall from -HEAD(or beta1).

Stefan

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Stefan Kaltenbrunner (#1)
Re: small pg_dumpall bug/warning in 8.1beta1

Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:

During testing of 8.1 I found that using pg_dumpall (-g) against a live
8.0 install that has at least one GROUP defined results in the following
warning while it creates the CREATE ROLE statements in the dump:
row number 0 is out of range 0..-1

Fixed, thanks for the report!

AFAICT, this is purely cosmetic, and the dump is OK anyway. But it's
definitely an oversight.

regards, tom lane

#3Stefan Kaltenbrunner
stefan@kaltenbrunner.cc
In reply to: Tom Lane (#2)
Re: small pg_dumpall bug/warning in 8.1beta1

Tom Lane wrote:

Stefan Kaltenbrunner <stefan@kaltenbrunner.cc> writes:

During testing of 8.1 I found that using pg_dumpall (-g) against a live
8.0 install that has at least one GROUP defined results in the following
warning while it creates the CREATE ROLE statements in the dump:
row number 0 is out of range 0..-1

Fixed, thanks for the report!

AFAICT, this is purely cosmetic, and the dump is OK anyway. But it's
definitely an oversight.

Oh yeah - the dump is fine otherwise, thats why I labeled it a small
bug/warning :-)

Stefan