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

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Let psql process files with > 4,294,967,295 lines
Дата
Msg-id 20060730213040.GB10074@surnet.cl
обсуждение исходный текст
Ответ на Let psql process files with > 4,294,967,295 lines  (David Fetter <david@fetter.org>)
Ответы Re: Let psql process files with > 4,294,967,295 lines  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
David Fetter wrote:

Hi,

> 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.

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

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Let psql process files with > 4,294,967,295 lines
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Let psql process files with > 4,294,967,295 lines