Re: Assertions Dilemma

From: Sted Alana <Sted_Alana_at_hotmail.com>
Date: Sun, 28 Apr 2002 05:07:18 GMT
Message-ID: <3ccb8372_1@news.iprimus.com.au>

>Jonathan Gennick wrote:
> An immediate constraint is one that is checked immediately after a
statement executes.

Do you mean after a SQL statement for example? or when you define a table?

>A deferred constraint is one that is not checked until you commit your
transaction.

Dont understand the term 'commit your transaction'.

>A deferred foreign-key constraint, for example, will allow you to insert
child >rows first and the parent row last, and everything will be ok as long as you have it all straight when you commit.

Ok. This sounds like disabling a contraint and enabling it again when the tables have been created.

> I don't understand the second part of your question.

The book I am currently reading makes note of assertions with partial rollback and rollback. Received on Sun Apr 28 2002 - 00:07:18 CDT