Re: BUG #11022: \copy report negative row number - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #11022: \copy report negative row number
Date
Msg-id 53CF55E6.30502@hogranch.com
Whole thread Raw
In response to Re: BUG #11022: \copy report negative row number  (Jov <amutu@amutu.com>)
List pgsql-bugs
On 7/22/2014 11:25 PM, Jov wrote:
> I think so.
> 32 bit counter can count ~ 4 billion rows,this file has 6 billion rows.

a 32 bit integer counts to ~2 billion then wraps around to -2 billion.
(2^31-1 and -2^31 to be precise)



--
john r pierce                                      37N 122W
somewhere on the middle of the left coast

pgsql-bugs by date:

Previous
From: Jov
Date:
Subject: Re: BUG #11022: \copy report negative row number
Next
From: Marti Raudsepp
Date:
Subject: Re: BUG #10972: string_agg function incorrectly concatenating varying delimiter