Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Let psql process files with > 4,294,967,295 lines
Date
Msg-id 4147.1154295616@sss.pgh.pa.us
Whole thread Raw
In response to Re: Let psql process files with > 4,294,967,295 lines  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: Let psql process files with > 4,294,967,295 lines  (David Fetter <david@fetter.org>)
List pgsql-hackers
Tree view 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> David Fetter wrote:
>> 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.

> The only thing I can tell you is that you should use INT64_FORMAT
> instead of %lld.

And the datatype should be declared int64, not "long long" which doesn't
exist everywhere.

Actually you probably want uint64 and UINT64_FORMAT...
        regards, tom lane

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Let psql process files with > 4,294,967,295 lines
Next
From: David Fetter
Date:
Subject: Re: request: support of array in plperl OUT arguments