13 Mar
2006
13 Mar
'06
8:59 a.m.
Joao Pereira napsal(a):
Ok, then what version of serweb is having less
problems with PostgreSQL?
You can try version from CVS. But you have to use also SER from CVS. New
serweb is not backward compatible with SER 0.9.x - DB schema has been
changed.
Or I can try changing this query:
select max(abs(username)) from aliases where domain='mydomain.pt' and
username REGEXP "^[0-9]+$"
to something more "postgre like".
But I cant find it in the code... where are the SQL querys in the serweb
code?
The SQL queries are in files in data_layer directory. If you enable
logging in serweb you should see location of query in log file.
But change of this one query do not solve your problem. There are more
queries which not work in postgres.
Karel
Thanks
Joao Pereira
Karel Kozlik wrote:
Hi,
sorry, but support for postgres is only experimental and not working
well in last stable version of serweb.
Real support for postgres will be ready in next version.
regards Karel
Joao Pereira napsal(a):
> Hello to all
> I installed the last serweb, but I had one problem registering users.
> When the users receive the confirmation email, they have to go to the
> confirmation link, and this confirmation link does this select in the
> DB:
>
> select max(abs(username)) from aliases where domain='mydomain.pt' and
> username REGEXP "[0-9]+$";
>
> ERROR: syntax error at or near "REGEXP" at character 79
> LINE 1: ...om aliases where domain='mydomain.pt' and username REGEXP
> "[0...
>
> ^
>
> (the ^ is under REGEXP)
>
> I m using PostgreSQL 8.0.0, and I believe the problem is with the
> postgres support of REGEXP...
> I googled and googled and I didnt found a solution yet.
> Did anyone had this problem too?
> Thanks
> Joao Pereira
>
> _______________________________________________
> Serusers mailing list
> serusers(a)lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers