[Devel] CVS commitlog: sip-server/modules/postgres db_val.c dbase.c dbase.h

[Klaus Darilion]

Bogdan-Andrei Iancu wrote:
> Hi Klaus,
> 
> according to PG docs, PQescapeStringConn has as older version the 
> PQescapeString function . See:
>    http://www.postgresql.org/docs/7.4/static/libpq-exec.html  Chapter 
> 27.3.4
> 
> do you think we can do some autodetection at compile time? actually does 
> it pay the effort? how old are the postgres versions that do not support 
> PQescapeString...

The following postgres version do not support PQescapeStringConn

PostgreSQL 8.1.x before 8.1.4, 8.0.x before 8.0.8, 7.4.x before 7.4.13, 
7.3.x before 7.3.15

Debian Sarge uses 7.4.7 but has backported the function to this version. 
I would think all other major distributions should have backported this 
function - thus updating should be easy for others too.

regards
klaus

> 
> regards,
> bogdan
> 
> Klaus Darilion wrote:
> 
>> User: klaus_darilion
>> Date: 2007/01/17 04:43:55 PST
>>
>>  OpenSER CVS - Commit Details
>>
>>  Modified files:        (Branch: rel_1_0_0)
>>    modules/postgres     db_val.c dbase.c dbase.h  Commit Log:
>>  - escape values before contructing the SQL statement
>>    NOTE: It uses the function PQescapeStringConn. Make sure your postgres
>>    library supports this function before update. E.g. on Debian Sarge 
>> you need
>>    at least postgres-devel and libpq3 version 7.4.7-6sarge3 (version
>>    7.4.7-6sarge1 does not work).
>>  
>>  Revision     Changes    Path
>>  1.3.2.1      +21 -13    sip-server/modules/postgres/db_val.c
>>   [ 
>> http://openser.cvs.sourceforge.net/openser/sip-server/modules/postgres/db_val.c?r1=1.3&r2=1.3.2.1 
>> ]
>>  1.4.2.1      +12 -12    sip-server/modules/postgres/dbase.c
>>   [ 
>> http://openser.cvs.sourceforge.net/openser/sip-server/modules/postgres/dbase.c?r1=1.4&r2=1.4.2.1 
>> ]
>>  1.1.1.1.4.1  +2 -2      sip-server/modules/postgres/dbase.h
>>   [ 
>> http://openser.cvs.sourceforge.net/openser/sip-server/modules/postgres/dbase.h?r1=1.1.1.1&r2=1.1.1.1.4.1 
>> ]
>>
>> _______________________________________________
>> Devel mailing list
>> Devel at openser.org
>> http://openser.org/cgi-bin/mailman/listinfo/devel
>>
>>  
>>
> 


-- 
Klaus Darilion
nic.at