Thread: small pg_dumpall bug/warning in 8.1beta1

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

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

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