Re: postgresql vs mysql - Mailing list pgsql-general

From Jim Nasby
Subject Re: postgresql vs mysql
Date
Msg-id 85E281A6-9FB7-426C-AC68-3808132E832F@decibel.org
Whole thread Raw
In response to Re: postgresql vs mysql  ("Adam Rich" <adam.r@sbcglobal.net>)
Responses Re: postgresql vs mysql  (Andreas 'ads' Scherbaum <adsmail@wars-nicht.de>)
List pgsql-general
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)



pgsql-general by date:

Previous
From: "Ted Byers"
Date:
Subject: Re: php professional
Next
From: Jim Nasby
Date:
Subject: Re: postgresql vs mysql