Hi Katie, Development indicate that the default is NO ACTION, but that we do not have that keyword in the SQL grammar, thus the 9.8.7.1 section needs to be corrected in the docs ...
Best Regards Hugh Williams Professional Services OpenLink Software, Inc. // http://www.openlinksw.com/ Weblog -- http://www.openlinksw.com/blogs/ LinkedIn -- http://www.linkedin.com/company/openlink-software/ Twitter -- http://twitter.com/OpenLink Google+ -- http://plus.google.com/100570109519069333827/ Facebook -- http://www.facebook.com/OpenLinkSoftware Universal Data Access, Integration, and Management Technology Providers On 26 Sep 2014, at 22:44, cha...@rpi.edu wrote: > Hello, > > My name is Katie Chastain. I'm a student at RPI, and I'm trying to modify > an SQL schema to work on Virtuoso. The original schema uses ON UPDATE and > ON DELETE foreign key constraints, and Virtuoso is giving me errors on > "NO ACTION" for these. > > In the documentation for the CREATE TABLE statement, the grammar lists > only CASCADE, SET NULLX, and SET DEFAULT as options for foreign key > constraint actions, but 9.8.7.1 below also includes NO ACTION as an > available activity. Is NO ACTION considered the default if the ON > UPDATE/ON DELETE clause is left out entirely? Or is there another default > effect? > > Thank you in advance for your help, > ~Katie Chastain > > > > ------------------------------------------------------------------------------ > Meet PCI DSS 3.0 Compliance Requirements with EventLog Analyzer > Achieve PCI DSS 3.0 Compliant Status with Out-of-the-box PCI DSS Reports > Are you Audit-Ready for PCI DSS 3.0 Compliance? Download White paper > Comply to PCI DSS 3.0 Requirement 10 and 11.5 with EventLog Analyzer > http://pubads.g.doubleclick.net/gampad/clk?id=154622311&iu=/4140/ostg.clktrk > _______________________________________________ > Virtuoso-users mailing list > Virtuoso-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Slashdot TV. Videos for Nerds. Stuff that Matters. http://pubads.g.doubleclick.net/gampad/clk?id=160591471&iu=/4140/ostg.clktrk
_______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
