[Pgsql-ayuda] [Fwd: [HACKERS] Second decent PostgreSQL CBT released - Introduction to Referential Integrity]

[Roberto Andrade Fonseca]

--=-4lHJDKemtZYQt/Z4nnqw
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hola:

Ech=E9nle un ojo a este bueno y bien presentado CBT (computer based
training) de integridad referencial.

No me jal=F3 con Opera, pero si con Gale=F3n. Tal qez requiera Flash.

Ai' me comentan.
--=20
Saludos,

Roberto Andrade Fonseca
randrade@abl.com.mx

--=-4lHJDKemtZYQt/Z4nnqw
Content-Disposition: inline
Content-Description: Reenviado mensaje - [HACKERS] Second decent PostgreSQL
	CBT released - Introduction to Referential  Integrity
Content-Type: message/rfc822

Return-Path: <pgsql-hackers-owner+M18920@postgresql.org>
Received: from server1.pgsql.org (www.postgresql.org [64.49.215.9]) by
	inter.interservice.com.mx (8.11.6/8.11.6) with SMTP id g1IKcOS28440 for
	<randrade@interservice.com.mx>; Mon, 18 Feb 2002 14:38:25 -0600
Received: (qmail 29986 invoked by alias); 18 Feb 2002 20:34:31 -0000
Received: from unknown (HELO postgresql.org) (64.49.215.8) by
	www.postgresql.org with SMTP; 18 Feb 2002 20:34:31 -0000
Received: from mta08.mail.mel.aone.net.au (mta08.mail.au.uu.net
	[203.2.192.89]) by postgresql.org (8.11.3/8.11.4) with ESMTP id
	g1IKSAE28365; Mon, 18 Feb 2002 15:28:11 -0500 (EST) (envelope-from
	justin@postgresql.org)
Received: from postgresql.org ([63.34.210.47]) by
	mta08.mail.mel.aone.net.au with ESMTP id
	<20020218202810.IFXR19709.mta08.mail.mel.aone.net.au@postgresql.org>; Tue,
	19 Feb 2002 07:28:10 +1100
Message-ID: <3C716362.C8D7EC20@postgresql.org>
Date: Tue, 19 Feb 2002 07:26:10 +1100
From: Justin Clift <justin@postgresql.org>
X-Mailer: Mozilla 4.78 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
To: PostgreSQL Announce Mailing List <pgsql-announce@postgresql.org>, PostgreSQL General Mailing List <pgsql-general@postgresql.org>, PostgreSQL Hackers Mailing List <pgsql-hackers@postgresql.org>
Subject: [HACKERS] Second decent PostgreSQL CBT released - Introduction to
	Referential  Integrity
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org
Status:  O

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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html

--=-4lHJDKemtZYQt/Z4nnqw--