Skip site navigation (1) Skip section navigation (2)

Re: Let psql process files with > 4,294,967,295 lines

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: David Fetter <david(at)fetter(dot)org>, PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Let psql process files with > 4,294,967,295 lines
Date: 2006-07-30 21:40:16
Message-ID: 4147.1154295616@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Alvaro Herrera <alvherre(at)commandprompt(dot)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

In response to

Responses

pgsql-hackers by date

Next:From: Tzahi FadidaDate: 2006-07-30 22:12:38
Subject: Adding fulldisjunctions to the contrib
Previous:From: Alvaro HerreraDate: 2006-07-30 21:30:40
Subject: Re: Let psql process files with > 4,294,967,295 lines

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group