[Asterisk-Dev] Re: PostgreSQL support in Asterisk 1.2?

[Brian West]

On Aug 9, 2005, at 11:34 AM, Bob Goddard wrote:

>> What you have done here is proven exactly why you shouldn't use  
>> MySQL.
>>
>> The 2nd and 3rd queries should have FAILED with an error, NOT  
>> inserted
>> mangled data. The problem you now have is that you don't know if  
>> the zeros
>> you have in your table were inserted by you, or plucked our of the  
>> air by
>> MySQL!! You have now compromised the integrity your entire table!!!
>>
>
> The issue was that it would insert crap data without errors or  
> warnings.
> What was inserted, although it may not be what you want, is valid.
> The other point is that it was flagged as a warning.
>

It still should have failed and NOT inserted the information.

/b

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.digium.com/pipermail/asterisk-dev/attachments/20050809/9f92d1a0/attachment.htm