This note is currently in the 'Dependency Tracking (2.8)' section:
Note: According to the SQL standard, specifying either RESTRICT or
CASCADE is required. No database system actually implements it that way,
but the defaults might be different.
If the defaults are different, perhaps the documentation should show
it's examples using RESTRICT or CASCADE explicitly?