Using foreign keys and transactions in Postgres? You should be interested in this patch :)