Horton

Re: [HACKERS] Re: ALTER TABLE DROP COLUMN

Jan Wieck <wieck@debis.com>

View thread
From: wieck@debis.com (Jan Wieck)
To: Jan Wieck <wieck@debis.com>
Cc: Hannu Krosing <hannu@tm.ee>, Don Baccus <dhogaza@pacifier.com>, Tom Lane <tgl@sss.pgh.pa.us>, PostgreSQL Development <pgsql-hackers@postgreSQL.org>
Date: 2000-02-29T12:22:19Z
Lists: pgsql-hackers 
I wrote:

>     fully  SQL3.  I just had an idea that might easily turn it to
>     do the right thing.

    ON  <event>  RESTRICT  triggers  are  now  executed after the
    statement allways, ignoring any explicitly set deferred mode.

    This  is  pretty close to Date's SQL3 interpretation, or IMHO
    better. Date says that they are checked BEFORE each ROW,  but
    that  would  ignore  the SET character of a statement. Now we
    have  correct  semantics  for  all  4  possible   referential
    actions.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#========================================= wieck@debis.com (Jan Wieck) #