| From: | Jim Nasby <decibel(at)decibel(dot)org> |
|---|---|
| To: | Adam Rich <adam(dot)r(at)sbcglobal(dot)net> |
| Cc: | "'Ron Johnson'" <ron(dot)l(dot)johnson(at)cox(dot)net>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: postgresql vs mysql |
| Date: | 2007-02-22 23:14:11 |
| Message-ID: | 85E281A6-9FB7-426C-AC68-3808132E832F@decibel.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim Nasby | 2007-02-22 23:17:35 | Re: postgresql vs mysql |
| Previous Message | Ted Byers | 2007-02-22 23:03:06 | Re: php professional |