-- -- content_type__create_attribute/8 -- create or replace function content_type__create_attribute( character varying, character varying, character varying, character varying, character varying, integer, character varying, character varying ) returns int4 as $$ declare create_attribute__content_type alias for $1; create_attribute__attribute_name alias for $2; create_attribute__datatype alias for $3; create_attribute__pretty_name alias for $4; create_attribute__pretty_plural alias for $5; -- default null create_attribute__sort_order alias for $6; -- default null create_attribute__default_value alias for $7; -- default null create_attribute__column_spec alias for $8; -- default 'text' v_attr_id acs_attributes.attribute_id%TYPE; v_table_name acs_object_types.table_name%TYPE; v_column_exists boolean; begin -- add the appropriate column to the table select table_name into v_table_name from acs_object_types where object_type = create_attribute__content_type; if NOT FOUND then raise EXCEPTION '-20000: Content type % does not exist in content_type.create_attribute', create_attribute__content_type; end if; select count(*) > 0 into v_column_exists from pg_class c, pg_attribute a where c.relname::varchar = v_table_name and c.oid = a.attrelid and a.attname = lower(create_attribute__attribute_name); v_attr_id := acs_attribute__create_attribute ( create_attribute__content_type, create_attribute__attribute_name, create_attribute__datatype, create_attribute__pretty_name, create_attribute__pretty_plural, null, null, create_attribute__default_value, 1, 1, create_attribute__sort_order, 'type_specific', 'f', not v_column_exists, null, null, null, null, null, create_attribute__column_spec ); PERFORM content_type__refresh_view(create_attribute__content_type); return v_attr_id; end;$$ language plpgsql;