Index: openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql,v
diff -u -r1.57 -r1.58
--- openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	30 Jun 2004 18:20:02 -0000	1.57
+++ openacs-4/packages/acs-kernel/sql/postgresql/apm-create.sql	1 Jul 2004 11:29:17 -0000	1.58
@@ -227,7 +227,8 @@
 
 create index apm_packages_package_key_idx on apm_packages (package_key);
 
-alter table acs_objects add foreign key (package_id) references apm_packages(package_id);
+-- This cant be added at table create time since acs_objects is created before apm_packages;
+alter table acs_objects add constraint acs_objects_package_id_fk foreign key (package_id) references apm_packages(package_id);
 
 comment on table apm_packages is '
    This table maintains the list of all package instances in the sytem. 
Index: openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql	8 Oct 2003 11:30:22 -0000	1.12
+++ openacs-4/packages/acs-kernel/sql/postgresql/authentication-create.sql	1 Jul 2004 11:29:17 -0000	1.13
@@ -49,9 +49,13 @@
                              references acs_objects(object_id),
     -- batch sync
     -- auth_sync_retrieve implementation
-    get_doc_impl_id          integer references acs_objects(object_id),
+    get_doc_impl_id          integer 
+                             constraint auth_authority_getdoc_impl_fk
+                             references acs_objects(object_id),
     -- auth_sync_process implementation
-    process_doc_impl_id      integer references acs_objects(object_id),
+    process_doc_impl_id      integer 
+                             constraint auth_authority_procdoc_impl_fk
+                             references acs_objects(object_id),
     batch_sync_enabled_p     boolean default 'f'
                              constraint auth_authority_bs_enabled_p_nn
                              not null
Index: openacs-4/packages/acs-kernel/sql/postgresql/lob.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/lob.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-kernel/sql/postgresql/lob.sql	11 Dec 2003 21:39:52 -0000	1.3
+++ openacs-4/packages/acs-kernel/sql/postgresql/lob.sql	1 Jul 2004 11:29:17 -0000	1.4
@@ -19,7 +19,8 @@
 create sequence lob_sequence;
 
 create table lobs (
-	lob_id			integer not null primary key,
+	lob_id			integer not null 
+                            constraint lobs_lob_id_pk primary key,
 	refcount		integer not null default 0
 );
 
@@ -33,11 +34,14 @@
 for each row execute procedure on_lobs_delete();
 
 create table lob_data (
-	lob_id			integer not null references lobs,
-	segment			integer not null,
-	byte_len		integer not null,
-	data			bytea not null,
-	primary key (lob_id, segment)
+        lob_id              integer not null
+                            constraint lob_data_lob_id_fk
+                            references lobs on delete cascade,
+        segment             integer not null,
+        byte_len            integer not null,
+        data                bytea not null,
+        constraint lob_data_lob_id_segment_pk
+        primary key (lob_id, segment)
 );
 
 create index lob_data_index on lob_data(lob_id);