Re: postgresql - dialup-admin

[Truong Manh Cuong]

I try to create table in dialup_admin/sql directory, and it come to fail.

ERROR:  parser: parse error at or near "("
and dialup_admin will not work with database fields in lower case. because of query sentence like this:

SELECT UserName,AcctStopTime ... FROM..WHERE  UserName ..

and the result of that query sentence will differ to SELECT username,acctstoptime ... FROM..WHERE  username ..

 

If all database is in lower case, I must change all code (PHP file) in dialup_admin. do you understand ?

 

Thanks for your support.

Manh Cuong.

 

----- Original Message -----

From: "Peter Nixon" <[EMAIL PROTECTED]>

To: <[EMAIL PROTECTED]>

Sent: Thursday, August 07, 2003 4:39 PM

Subject: Re: postgresql - dialup-admin

> 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