How to determine max int - Mailing list pgsql-general

From Melvin Call
Subject How to determine max int
Date
Msg-id CADGQN55MrWn0DDEueqALH6QqH4xA-R05dBjnXT+ztys3=-WvgA@mail.gmail.com
Whole thread Raw
Responses Re: How to determine max int  (John R Pierce <pierce@hogranch.com>)
Re: How to determine max int  (Guy Rouillier <guy.rouillier@gmail.com>)
List pgsql-general
Good evening,

I could swear I read somewhere that the default integer size on 64-bit systems running 9.1 is eight bytes, or the equivalent of a bigint. But reading through the user guide it seems that it is indeed still just four-bytes. Can anyone verify that for me, or point me to a way to verify it? I see nothing in pg_settings which is where I thought to look. Not a big deal, I just need to know for the data dictionary.

Thanks again,
Melvin

pgsql-general by date:

Previous
From: Melvin Call
Date:
Subject: Re: Limiting/disallowing changes of certain columns
Next
From: Jeffrey Walton
Date:
Subject: Postgres 9.3.1 and Self Test Failure "pg_regress: no *.source files found"