"Pirtea Calin" <pcalin(at)rdsor(dot)ro> writes:
> I tried inserting this in an int8 integer: 9223372036854775807 and failed.
How old a version are you using, on what platform? It works for me:
regression=# create table foo (f1 int8);
CREATE
regression=# insert into foo values (9223372036854775807);
INSERT 1873745 1
regression=# select * from foo;
f1
---------------------
9223372036854775807
(1 row)
regression=#
regards, tom lane