[OpenSER-Devel] SF.net SVN: openser: [3972] trunk

[Daniel-Constantin Mierla]

Hello,

On 04/03/08 20:45, Dan Pascu wrote:
> On Thursday 03 April 2008, Henning Westerholt wrote:
>   
>> On Thursday 03 April 2008, Dan Pascu wrote:
>>     
>>> Why was the date column in the sip_trace table renamed?
>>> Such changes are very disruptive.
>>>       
>> Hi Dan,
>>
>> because 'date' is a reserved word in oracle [1], and we want to add a
>> driver for this DB in the trunk.
>>     
>
> Isn't there a way to quote reserved words when used as column names in 
> oracle? In mysql one can use backticks in case a column name is a 
> reserved word, like `condition`, while in postgres one can use single 
> quotes for the same purpose. This would be less disruptive and would 
> preserve backward compatibility.
>   
there is the option to set the column name via module parameters in 
siptrace module. Therefore the existing table structure and additional 
external tools can be kept untouched, just set the parameter in the 
configuration file.

Cheers,
Daniel

-- 
http://www.asipto.com