SET CONSTRAINTS sets the behavior of constraint checking within the current transaction. IMMEDIATE constraints are checked at the end of each statement. DEFERRED constraints are not checked until ...
Use RESET ALL to remove all such configuration entries. Values set with ALTER SYSTEM will be effective after the next server configuration reload, or after the next server restart in the case of ...