Re: maxint reached?

>>>Tom Lane said:
> Daniel Kalchev <daniel(at)digsys(dot)bg> writes:
> > So in essence this means that my best bet is to again dump/reload the
> > database...
>
> Either that or fix your queries to cast the literals explicitly.

Sorry for the incomplete reply:

this does not work:

customer=# select max(oid) from croute;
max
-------------
-2144025472
(1 row)

this does work:

customer=# select oid(max(oid)) from croute;
oid
------------
2150941824
(1 row)

weird, isn't it? I guess max should return the same type as it's arguments, no?

Daniel