[Serusers] serrweb regex problem

[Karel Kozlik]

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 at lists.iptel.org
> http://lists.iptel.org/mailman/listinfo/serusers