Hi everyone,
Just wrapped up the 2nd in the series of PostgreSQL CBT's.
This one introduces the concepts of Referential Integrity :
http://techdocs.postgresql.org/college/002_referentialintegrity/index.php
It covers :
- The basic concepts
- Creating single column primary and foreign keys
- The optional clauses ON UPDATE and ON DELETE (and their
options NO ACTION/RESTRICT, CASCADE, SET NULL, SET DELETE)
- Dropping tables when they have RI constraints
This CBT doesn't cover multi-column keys, nor MATCH, MATCH FULL, MATCH
PARTIAL, as I ran out of time. Have to hold them over for another CBT.
:)
I've REALLY interested in what people think of the new look (a bunch of
improvements due to people's suggestions), and if people can suggest
further improvements/fixes/etc, they'll also be incorporated into
further CBT's.
Hope people find it worthwhile and useful.
:-)
Regards and best wishes,
Justin Clift
P.S. - Wow, what a beautiful sunrise out my window. Was worth the
effort just for that. :)
--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi