CREATE OR REPLACE PROCEDURE sp_delete_restaurante_msg
                           ( _id_restaurante   integer,
                             _id_local         integer,
                             _nome_restaurante varchar(100),
                             INOUT _msg        varchar(100),
                             INOUT _msg1       varchar(100) )
LANGUAGE plpgsql
AS $$
BEGIN

    DELETE FROM restaurante
    WHERE restaurante.id_restaurante = _id_restaurante;

    DELETE FROM local
    WHERE id_local = _id_local;

    DELETE FROM ementa
    WHERE ementa.id_restaurante = _id_restaurante;

    DELETE FROM funcionario
    WHERE funcionario.id_restaurante = _id_restaurante;

    ...
END;
$$