You are correct that it shouldn't be storing timezone on this field, but it is perfectly valid to store a timestamp without a timezone in a timestamp with timezone field. this will not cause an error.
I have updated the db schema in CVS with this and a number of other fixes. I need to spend more time on it later though. In any case I still want to know what the problem is that Salvin is seeing.. Debug logs asap please.... Peter On Fri, 11 Jul 2003 07:42 am, Truong Manh Cuong wrote: > This is a flault that I met when I began to use with postgresql. so , have > fun: AcctStartTime timestamptz, > AcctStopTime timestamptz, > --> > AcctStartTime timestamp without time zone > AcctStopTime timestamp without time zone > > Cheers! > Manh Cuong. > ----- Original Message ----- > From: Salvin Kumar > To: [EMAIL PROTECTED] > Sent: Friday, July 11, 2003 7:50 AM > Subject: postgres error > > > When I am trying to start the radius server and do accounting ith > postgres I get some errors when the values are being inserted: > > ERROR: "Bad numeric input format '' > LOG: connection received: host=localhost.is.com.fj[127.0.0.1] port=1121 > LOG: connection authorized: user=postgres database=radius > ERROR: "Bad numeric input format '' > > and this is how my radacct table looks: > > RadAcctId SERIAL, > AcctSessionId VARCHAR(32) DEFAULT '' NOT NULL, > AcctUniqueId VARCHAR(32) DEFAULT '' NOT NULL, > UserName VARCHAR(32) DEFAULT '' NOT NULL, > Realm VARCHAR(30) DEFAULT '', > NASIPAddress VARCHAR(15) DEFAULT '' NOT NULL, > NASPortId NUMERIC(12), > NASPortType VARCHAR(32), > AcctStartTime timestamptz, > AcctStopTime timestamptz, > AcctSessionTime NUMERIC(12), > AcctAuthentic VARCHAR(32), > ConnectInfo_start VARCHAR(32), > ConnectInfo_stop VARCHAR(32), > AcctInputOctets NUMERIC(12), > AcctOutputOctets NUMERIC(12), > CalledStationId VARCHAR(10) DEFAULT '' NOT NULL, > CallingStationId VARCHAR(10) DEFAULT '' NOT NULL, > AcctTerminateCause VARCHAR(32) DEFAULT '' NOT NULL, > ServiceType VARCHAR(32), > FramedProtocol VARCHAR(32), > FramedIPAddress VARCHAR(15) DEFAULT '' NOT NULL, > AcctStartDelay NUMERIC(12), > AcctStopDelay NUMERIC(12), > PRIMARY KEY (RadAcctId) > ); -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
