>
> looks strange to me too, but i never had foreign keys to the same table.
> it works if you define your chekced_by FK deferrable with
>
> checked_by INT REFERENCES users (id) ON UPDATE CASCADE ON DELETE SET NULL
> DEFERRABLE INITIALLY DEFERRED,
>
> it seams that postgresql does its job in a procedural way instead of
> relational.
>
It is solved. It was PostgreSQL bug repaired
http://archives.postgresql.org/pgsql-committers/2007-08/msg00207.php
Thank you
nice a day
Pavel Stehule