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 -N -r1.40.2.1 -r1.40.2.2 --- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 8 Jun 2005 21:12:11 -0000 1.40.2.1 +++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql 3 Dec 2005 20:57:16 -0000 1.40.2.2 @@ -310,7 +310,7 @@ -- Drop the column if neccessary if drop_attribute__drop_column then execute ''alter table '' || v_table || '' drop column '' || - drop_attribute__attribute_name || '' cascade''; + drop_attribute__attribute_name || '' cascade''; -- exception when others then -- raise_application_error(-20000, ''Unable to drop column '' || @@ -487,7 +487,7 @@ attr_rec record; begin if trigger_insert_statement__content_type is null then - return exception ''content_type__trigger_insert_statement called with null content_type''; + return exception ''content_type__trigger_insert_statement called with null content_type''; end if; select @@ -758,7 +758,7 @@ -- procedure register_child_type -select define_function_args('content_type__register_child_type','content_type,child_type,relation_tag;generic,min_n;0,max_n'); +select define_function_args('content_type__register_child_type','parent_type,child_type,relation_tag;generic,min_n;0,max_n'); create or replace function content_type__register_child_type (varchar,varchar,varchar,integer,integer) returns integer as ' declare @@ -923,7 +923,7 @@ where not exists ( select 1 from - cr_content_mime_type_map + cr_content_mime_type_map where mime_type = register_mime_type__mime_type and