FOREIGN KEY: difference between NOT DEFERRABLE and INITIALLY IMMEDIATE

From: Gabriel Fernandez <gabi(at)unica(dot)edu>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: FOREIGN KEY: difference between NOT DEFERRABLE and INITIALLY IMMEDIATE
Date: 2001-09-04 17:08:04
Message-ID: 3B950A73.7F9D9A71@unica.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

What's the difference between NOT DEFERRABLE and INITIALLY IMMEDIATE for
a FOREIGN KEY specification ?

It seems they are both defining the same: the moment the constraint will
be checked: the instant the statement is processed or the end of
transaction.

Thanks,

Gabi :-)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-09-04 17:19:43 Re: Index usage question
Previous Message Tony Grant 2001-09-04 17:05:45 Re: [WAY OT] Re: PL/java?