Re: Problema con DEFERRED CONSTRAINTS

> peticiones_articulos_fk -> FOREIGN KEY (articulo_id) REFERENCES
> articulos(id) ON UPDATE RESTRICT ON DELETE RESTRICT DEFERRABLE INITIALLY
> DEFERRED
>
> ¿No se supone que al estar la restricción declarada como INITIALLY
> DEFERRED no comprueba las restricciones hasta que termina la transacción?
>

Según la documentación, la acción referencial...
NO ACTION:
Produce an error indicating that the deletion or update would
create a foreign key constraint violation. If the constraint is
deferred, this error will be produced at constraint check time if
there still exist any referencing rows. This is the default action.

RESTRICT: Produce an error indicating that the deletion or update
would create a foreign key constraint violation. This is the same as
NO ACTION except that the check is not deferrable.

Es decir, que si cambias el restrict por no action te funciona como quieres.
Curioso el comportamiento, de todas formas :)

Saludos
--
Miguel