Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Let psql process files with > 4,294,967,295 lines
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: David Fetter <david(at)fetter(dot)org>
- Cc: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
- Subject: Re: Let psql process files with > 4,294,967,295 lines
- Date: Sun, 30 Jul 2006 17:30:40 -0400
- Message-id: <20060730213040.GB10074@surnet.cl> <text/plain>
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
- Follow-Ups:
- Re: Let psql process files with > 4,294,967,295 lines
- From: Tom Lane
- Re: Let psql process files with > 4,294,967,295 lines
- References:
- Let psql process files with > 4,294,967,295 lines
- From: David Fetter
- Let psql process files with > 4,294,967,295 lines
- Prev by Date: Let psql process files with > 4,294,967,295 lines
- Next by Date: Re: Let psql process files with > 4,294,967,295 lines
- Previous by thread: Let psql process files with > 4,294,967,295 lines
- Next by thread: Re: Let psql process files with > 4,294,967,295 lines
- Indexes: