PostgreSQL: deshabilitar un disparador

En PostgreSQL , no hay DISABLE TRIGGER the ALTER TABLE

Syntax: 
ALTER TABLE table_name
DISABLE TRIGGER trigger_name | ALL

Analicemos la sintaxis anterior:

• Primero, DESACTIVAR EL DISPARADOR
• TODOS

,

CREATE TABLE staff(
    user_id serial PRIMARY KEY,
    username VARCHAR (50) UNIQUE NOT NULL,
    password VARCHAR (50) NOT NULL,
    email VARCHAR (355) UNIQUE NOT NULL,
    created_on TIMESTAMP NOT NULL,
    last_login TIMESTAMP
);

CREATE FUNCTION check_staff_user()
    RETURNS TRIGGER
AS $$
BEGIN
    IF length(NEW.username) < 8 OR NEW.username IS NULL THEN
        RAISE EXCEPTION 'The username cannot be less than 8 characters';
    END IF;
    IF NEW.NAME IS NULL THEN
        RAISE EXCEPTION 'Username cannot be NULL';
    END IF;
    RETURN NEW;
END;
$$
LANGUAGE plpgsql;

personal

CREATE TRIGGER username_check 
    BEFORE INSERT OR UPDATE
ON staff
FOR EACH ROW 
    EXECUTE PROCEDURE check_staff_user();

Ahora podemos deshabilitar el username_check activado usando la siguiente declaración:

ALTER TABLE staff
DISABLE TRIGGER username_check;