Re: postgres error

[Truong Manh Cuong]

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) );