On Fri, Sep 27, 2002 at 09:50:18AM -0400, Paul Khavkine wrote: > 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.
So override it! You can freely edit database schema for your own: see src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_postgresql.sql. DATETIME type is for backward compatibility only, use TIMESTAMP/TIMESTAMP WITH TIME ZONE instead. I'd also recommend you remove all "DEFAULT '' NOT NULL" modifiers (it's also some kind of mySQLism) and change NUMERICs to [BIG]INTEGERs - they're faster. Note also that PostgreSQL 7.2+ drops an exception when trying to insert VARCHAR value larger than specified (unlike simply trimming it in earlier versions), so you can consider using TEXT instead in some places like ConnectInfo_*. -- Fduch M. Pravking - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
