Postgres Pro
Downloads
Home   >   mailing lists

Let psql process files with > 4,294,967,295 lines - Mailing list pgsql-hackers

From David Fetter
Subject Let psql process files with > 4,294,967,295 lines
Date
Msg-id 20060730212323.GU2654@fetter.org
Whole thread Raw
Responses Re: Let psql process files with > 4,294,967,295 lines  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-hackers
Tree view 
Folks,

I just ran across an issue where in psql, people can get the line
number in the file so long as it is under 2^32-1 lines long, but once
it gets larger than that, it's hosed.

This patch changes the data type from unsigned int to unsigned long
long, which is probably not the correct thing in order to get 64-bit
arithmetic, but I figure it's good enough to get a discussion started.

Cheers,
D
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778        AIM: dfetter666
                              Skype: davidfetter

Remember to vote!
Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Relation locking and relcache load (was Re: Going for "all green" buildfarm results)
Next
From: Alvaro Herrera
Date:
Subject: Re: Let psql process files with > 4,294,967,295 lines