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. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
