[vhffs-dev] [727] Fix constaint on vhffs_object.owner_uid and vhffs_object.owner_gid

[subversion@xxxxxxxxx]

Revision: 727
Author:   gradator
Date:     2007-07-16 20:51:06 +0000 (Mon, 16 Jul 2007)

Log Message:
-----------
Fix constaint on vhffs_object.owner_uid and vhffs_object.owner_gid

Modified Paths:
--------------
    trunk/vhffs-backend/src/pgsql/initdb.sql.in


Modified: trunk/vhffs-backend/src/pgsql/initdb.sql.in
===================================================================
--- trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-07-13 23:30:29 UTC (rev 726)
+++ trunk/vhffs-backend/src/pgsql/initdb.sql.in	2007-07-16 20:51:06 UTC (rev 727)
@@ -318,8 +318,8 @@
 
 ALTER TABLE vhffs_mysql ADD CONSTRAINT fk_vhffs_mysql_vhffs_object FOREIGN KEY (object_id) REFERENCES vhffs_object(object_id) ON DELETE CASCADE;
 
-ALTER TABLE vhffs_object ADD CONSTRAINT fk_vhffs_object_vhffs_user FOREIGN KEY (owner_uid) REFERENCES vhffs_users(uid) ON DELETE CASCADE;
-ALTER TABLE vhffs_object ADD CONSTRAINT fk_vhffs_object_vhffs_group FOREIGN KEY (owner_gid) REFERENCES vhffs_groups(gid) ON DELETE CASCADE;
+ALTER TABLE vhffs_object ADD CONSTRAINT fk_vhffs_object_vhffs_user FOREIGN KEY (owner_uid) REFERENCES vhffs_users(uid) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
+ALTER TABLE vhffs_object ADD CONSTRAINT fk_vhffs_object_vhffs_group FOREIGN KEY (owner_gid) REFERENCES vhffs_groups(gid) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED;
 
 ALTER TABLE vhffs_pgsql ADD CONSTRAINT fk_vhffs_pgsql_vhffs_object FOREIGN KEY (object_id) REFERENCES vhffs_object(object_id) ON DELETE CASCADE;