> > 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
