Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v
diff -u -r1.47 -r1.48
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	24 Sep 2006 11:37:05 -0000	1.47
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	25 Sep 2006 20:25:19 -0000	1.48
@@ -79,8 +79,8 @@
       where object_type = create_type__supertype;
 
     execute ''create table '' || create_type__table_name || '' ('' ||
-      create_type__id_column  || '' integer primary key references '' || 
-      v_supertype_table || '')'';
+      create_type__id_column || '' integer constraint '' || create_type__table_name || ''_pk primary key '' || 
+      '' constraint '' || create_type__table_name || ''_fk references '' || v_supertype_table || '')'';
   end if;
 
   PERFORM acs_object_type__create_type (