RLS - update documentation, regession tests and SET ROLE behavior.

SET ROLE will always set row_security to OFF when switching from
non-superuser to superuser.  Otherwise, it will leave the current
value as-is.