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
