On Fri, Jul 19, 2013 at 3:20 PM, Natalie Wenz <nataliewenz@xxxxxxxxxxx> 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 Cheers, Jeff -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
