Re: [HACKERS] Re: ALTER TABLE DROP COLUMN - Mailing list pgsql-hackers

From wieck@debis.com (Jan Wieck)
Subject Re: [HACKERS] Re: ALTER TABLE DROP COLUMN
Date
Msg-id m12PlfQ-0003kkC@orion.SAPserv.Hamburg.dsh.de
Whole thread Raw
In response to Re: [HACKERS] Re: ALTER TABLE DROP COLUMN  (wieck@debis.com (Jan Wieck))
Responses Re: [HACKERS] Re: ALTER TABLE DROP COLUMN  (Don Baccus <dhogaza@pacifier.com>)
List 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
deferredmode.
 
   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) #




pgsql-hackers by date:

Previous
From: Karel Zak - Zakkr
Date:
Subject: Re: [HACKERS] Re: [PATCHES] NO-CREATE-TABLE and NO-LOCK-TABLE
Next
From: Karel Zak - Zakkr
Date:
Subject: RE: [HACKERS] Cache query implemented