Re: BUG #11022: \copy report negative row number

I think so.
32 bit counter can count ~ 4 billion rows,this file has 6 billion rows.

Jov
blog: http:amutu.com/blog <http://amutu.com/blog>

2014-07-23 13:32 GMT+08:00 John R Pierce <pierce(at)hogranch(dot)com>:

> On 7/22/2014 10:15 PM, amutu(at)amutu(dot)com wrote:
>
>> psql 9.3.2
>> pg server 9.2.4
>>
>> when \copy a big file with 6billion rows,some one kill -9 the server，I
>> find
>> client message report negative row numbers：
>> CONTEXT: COPY a_xxx, line -1454214895:
>>
>
> so, the actual bug is that the 32 bit line counter wrapped around on this
> very large file?
>
> hmmm.
>
>
>
>
> --
> john r pierce 37N 122W
> somewhere on the middle of the left coast
>
>
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>