Yury. In the schema for postgres for radacct table: AcctStartTime datetime DEFAULT now() NOT NULL, AcctStopTime datetime DEFAULT now() NOT NULL,
So these can not be NULL. Yury Bokhoncovich wrote: > Hello! > > On Thu, 26 Sep 2002, Paul Khavkine wrote: > > > > > Hi. > > > > Anyone use rlm_sql_postgres for accounting ? > > Sure. > > > I seem to have a problem with the queries, i get errors when trying to > > insert 0 in acctstarttime or > > in brief: change sql.conf. You'd search thru this maillist archive for > ready recipe (Igor Khen had posted HOWTO, IIRC). > Personally me had made modifications in sql.conf and sql_modules to insert > NULL instead of 0. That's the way for PG. > > BTW, inserting 0 as acctstoptime is MySQLism, really, and it is goes > against the nature of SQL. Martin Gruber in his gave good clue why NULL > value was implemeted in SQL at all. Naturally, when start accounting, > acctstoptime has no meaningful value, right? This is what NULL value in > SQL is for. > > > acctstoptime, the DB backend complains that 0 is not a valid timestamp > > representation. > > -- > WBR, Yury Bokhoncovich, Senior System Administrator, NOC of F1 Group. > Phone: +7 (3832) 106228, ext.140, E-mail: [EMAIL PROTECTED] > Unix is like a wigwam -- no Gates, no Windows, and an Apache inside. > > - > List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html