[check_postgres] error on sequence with bigint

Greg Sabino Mullane greg at endpoint.com
Wed Nov 5 18:08:57 UTC 2008


> Trying to run 2.4.0 against a database with bigserial / bigsequences
> and I get this:
> 
> bin/check_postgres.pl -db www --action=sequence --warning=95%
> ERROR: ERROR:  bigint out of range

Fixed up in 2.4.1, just released. Turns out that the combo of min_value
and max_value can result in more than bigint possible sequence values, so
I added some ::numeric casts to the relevant SQL to handle that. Thanks to
Scott for the report and some off-list help in solving this.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20081105/7ae151cf/attachment.bin 


More information about the Check_postgres mailing list