Postgres Pro
Downloads
Home   >   mailing lists

Re: SQL standard changed behavior of ON UPDATE SET NULL/SET DEFAULT? - Mailing list pgsql-hackers

From Dean Rasheed
Subject Re: SQL standard changed behavior of ON UPDATE SET NULL/SET DEFAULT?
Date
Msg-id CAEZATCX3-GUhpaBWDCB+-nLE1a1OU5OP=n1n+W9+Rc1o3FS5ZA@mail.gmail.com
Whole thread Raw
In response to Re: SQL standard changed behavior of ON UPDATE SET NULL/SET DEFAULT?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view 
On 16 June 2012 21:18, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Anybody have DB2, or something else that might be thought to be pretty
> close to spec-compliant?
>

I have an Oracle DB, but they're not exactly known for spec
compliance. In fact they dodge this entire issue by not supporting ON
UPDATE actions at all :-)

Regards,
Dean

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: SQL standard changed behavior of ON UPDATE SET NULL/SET DEFAULT?
Next
From: Tom Lane
Date:
Subject: s/UNSPECIFIED/SIMPLE/ in foreign key code?