From: | Vik Fearing <vik(dot)fearing(at)dalibo(dot)com> |
---|---|
To: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
Cc: | Natalie Wenz <nataliewenz(at)ebureau(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: [GENERAL] Insert result does not match record count |
Date: | 2013-07-24 15:44:58 |
Message-ID: | 51EFF67A.7020509@dalibo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 07/24/2013 04:04 PM, Vik Fearing wrote:
> On 07/22/2013 06:20 PM, Jeff Janes wrote:
>> On Fri, Jul 19, 2013 at 3:20 PM, Natalie Wenz <nataliewenz(at)ebureau(dot)com> wrote:
>>> Hi all,
>>>
>>> I am moving some data from one table to another in 9.2.4, and keep seeing this strange scenario:
>>>
>>> insert into newtable select data from oldtable where proc_date >= x and proc_date < y;
>>>
>>> INSERT 0 78551642
>>>
>>> select count(*) from newtable where proc_date >= x and proc_date < y;
>>> count
>>> -----------
>>> 4373518938
>> It looks to me like the status report is 32 bits and overflowed.
>>
>> 4,373,518,938 - 2^32 = 78,551,642
> Attached is a small patch that should fix the problem.
It would seem this was not as thorough as it should have been and
there's a lot more to do. I'm working on a better patch.
Also worth mentioning is bug #7766.
http://www.postgresql.org/message-id/E1Tlli5-0007tR-HO@wrigleys.postgresql.org
Vik
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-07-24 17:48:23 | Re: [GENERAL] Insert result does not match record count |
Previous Message | Some Developer | 2013-07-24 14:40:12 | Re: Why are stored procedures looked on so negatively? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2013-07-24 15:49:20 | Re: ilist.h is not useful as-is |
Previous Message | Andres Freund | 2013-07-24 15:34:39 | Re: ilist.h is not useful as-is |