On Thu August 7 2003 12:29, Truong Manh Cuong wrote: > I wonder is there anyone use postgresql for freeradius? there is so many > thing I have to fix if I want to use postgres. > But freeradius staffs do not fix it. or may be I do wrong ?
Tell us and we will either fix the problems or explain to you why we did it that way :-) > is there any type like this: > CREATE TABLE badusers ( > id int(10) DEFAULT '0' NOT NULL auto_increment, > ... > "Date" timestamp with timezone DEFAULT '0000-00-00 00:00:00' NOT > NULL, > ... ); What do you wish this table to do? There is no such table in MySQL either, so I think you are mistaken if you believe this is a Postgres "problem". We can add such a table if there is a reason and the general public will find it useful. Please explain.. > and with postgresql_db.sql, every fields must have " " when they are > declared, but I don't see, so as the result, my db will have tables with > all fields in lowercase > Here is my sql file that fixed.(file attact) What is wrong with that? Lower case field names are much better all round. Why would you want case sensitive field names?? -- 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
