Necessary rant

From: Patrick Rigney <patrick_at_evocative.com>
Date: Fri Dec 5 16:30:46 2003

> <RANT FRUSTRATION=HIGH>
> Who's the asshole that decided an UPDATE command in SQL without a WHERE
> clause defaults to ALL?
> </RANT>

Ouch. Same for DELETE by the way.

This may be a good opportunity to pick up the thread about MySQL and other
databases. :-)

One of the things that mission-critical-appropriate databases provide, IMHO,
is a running transaction log or similar mechanism that facilitates not only
transaction management and rollback, but also backup and recovery up to a
point in time. I'm pretty sure MySQL doesn't offer this. Does anyone know
if PostgreSQL does?

Patrick
Received on Fri Dec 05 2003 - 16:30:46 GMT