Re: postgresql vs mysql

On Feb 20, 2007, at 11:59 PM, Adam Rich wrote:
> "As of 5.0.2, the server requires that month and day values
> be legal, and not merely in the range 1 to 12 and 1 to 31,
> respectively."

Yes, but any session is free to change that setting and insert
whatever garbage they want. AFAIK there's absolutely no way to
prevent that. So your data is still very much subject to getting
trashed.

Of course, there's also plenty of ways to do that on accident, mostly
involving mistakenly ending up with a MyISAM table instead of an
InnoDB one.
--
Jim Nasby                                            jim@nasby.net
EnterpriseDB      http://enterprisedb.com      512.569.9461 (cell)