Skip site navigation (1) Skip section navigation (2)

Second decent PostgreSQL CBT released - Introduction to Referential Integrity

From: Justin Clift <justin(at)postgresql(dot)org>
To: PostgreSQL Announce Mailing List <pgsql-announce(at)postgresql(dot)org>, PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>, PostgreSQL Hackers Mailing List <pgsql-hackers(at)postgresql(dot)org>
Subject: Second decent PostgreSQL CBT released - Introduction to Referential Integrity
Date: 2002-02-18 20:26:10
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-announcepgsql-generalpgsql-hackers
Hi everyone,

Just wrapped up the 2nd in the series of PostgreSQL CBT's.

This one introduces the concepts of Referential Integrity :

It covers :

- The basic concepts

- Creating single column primary and foreign keys

- The optional clauses ON UPDATE and ON DELETE (and their

- 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

pgsql-announce by date

Next:From: Steve HoweDate: 2002-02-21 00:12:23
Subject: Released pgExpress Driver v0.95
Previous:From: Turbo FredrikssonDate: 2002-02-08 09:16:51
Subject: Re: PostgreSQL v7.2 Final Release

pgsql-hackers by date

Next:From: Rod TaylorDate: 2002-02-18 20:28:15
Subject: Re: Serious 7.2 issue (non quiet string truncation)
Previous:From: Greg CopelandDate: 2002-02-18 19:38:07
Subject: Re: Ready to branch 7.2/7.3 ?

pgsql-general by date

Next:From: wsheldahDate: 2002-02-18 20:32:58
Previous:From: Andrew GouldDate: 2002-02-18 20:22:24
Subject: Re: Sum of events over an interval; how?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group