[Nottingham] TALK: Relational databases, SQL and PostgreSQL.

[Ovid]

--- David Aldred <david at familyaldred.org.uk> wrote:

> Sorry, but I'm still not seeing how this is critical where data
> updates are handled in single SQL statements.  
> 
> If related data lies in a number of tables, then it could be an
> issue, if the related data's mutual consistency is important - 
> but again, that's not my situation. 

If it's the case that you're only updating one table and not relying on
any others, than a transaction may very well be irrelevant.  However,
normalization is still important.

Cheers,
Ovid

--

Buy the book -- http://www.oreilly.com/catalog/perlhks/
Perl and CGI -- http://users.easystreet.com/ovid/cgi_course/