11 Mar
2006
11 Mar
'06
8:14 p.m.
Ok, then what version of serweb is having less problems with PostgreSQL?
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?
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