[Serusers] serrweb regex problem

[Joao Pereira]

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