"Alexander M. Pravking" wrote: > 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 replaced datetime with VARCHAR and it worked, but maybe not a good idea. I will play with the schema and post the results. The postgresql.conf that comes with FR seems to be broken out of the box. > > 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 - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html