| Lists: | pgsql-hackers |
|---|
| From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
|---|---|
| To: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | small pg_dumpall bug/warning in 8.1beta1 |
| Date: | 2005-08-28 13:48:02 |
| Message-ID: | 4311C092.90007@kaltenbrunner.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
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
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: small pg_dumpall bug/warning in 8.1beta1 |
| Date: | 2005-08-28 16:33:09 |
| Message-ID: | 24281.1125246789@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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
| From: | Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: small pg_dumpall bug/warning in 8.1beta1 |
| Date: | 2005-08-28 17:28:37 |
| Message-ID: | 4311F445.30107@kaltenbrunner.cc |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)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