26 Sep
2008
26 Sep
'08
5:05 a.m.
Vegard Svanberg wrote:
I have a NAS which sends a NAS-Port-Id attribute in the range 2147483648..2164260863. PostgreSQL doesn't like the query Freeradius performs. It's choking when trying to insert for instance '2163214239::integer' into the radacct table.
$ select 2163214239::integer; ERROR: integer out of range
It's treating the number as a signed 32-bit integer, and the number is greater than 2^31. And the NASPortId field in the default schema is VARCHAR, not integer. Hmm... the default queries add a "::integer" to the NAS-Port-Id. Why? Alan DeKok.