Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #5993: pg_size_pretty overflow - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5993: pg_size_pretty overflow
Date
Msg-id 20005.1303762997@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5993: pg_size_pretty overflow  ("nicola75ss" <nicola75ss@gmail.com>)
List pgsql-bugs
Tree view 
"nicola75ss" <nicola75ss@gmail.com> writes:
> Good morning. I'm totally newbie with postgresql. I was studying
> pg_size_pretty() and I've discovered that if I pass it a great value it
> returns negative value.

> This is an example

> select pg_size_pretty(9223372000000000000); -- "-8388607 TB"

Yeah, that's a bug.  Fixed, thanks for the report!

            regards, tom lane

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: [JDBC] [ADMIN] Missing documentation for error code: 80S01
Next
From: Dave Page
Date:
Subject: Re: BUG #5800: "corrupted" error messages (encoding problem ?)