Index: openacs-4/packages/ams/sql/postgresql/telecom-number-missing-plsql.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ams/sql/postgresql/telecom-number-missing-plsql.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/ams/sql/postgresql/telecom-number-missing-plsql.sql 18 May 2005 17:11:48 -0000 1.2 +++ openacs-4/packages/ams/sql/postgresql/telecom-number-missing-plsql.sql 28 May 2005 15:37:27 -0000 1.3 @@ -1,43 +1,43 @@ --- --- packages/ams/sql/postgresql/telecom-number-missing-plsql.sql --- --- @author Matthew Geddert openacs@geddert.com --- @creation-date 2004-09-07 --- @cvs-id $Id$ --- --- - --- --- This file can safely be deleted once telecom number fixes a bug #2099 --- I filed that has this code commented out --- - -create function inline_0 () -returns integer as ' -declare - v_telecom_number_p boolean; -begin - v_telecom_number_p := ''1'' from acs_object_types where object_type = ''telecom_number''; - - if v_telecom_number_p then - else - PERFORM acs_object_type__create_type ( - ''telecom_number'', -- object_type - ''Telecom Number'', -- pretty_name - ''Telecom Number'', -- pretty_plural - ''acs_object'', -- supertype - ''telecom_numbers'', -- table_name - ''number_id'', -- id_column - ''telecom_number'', -- package_name - ''f'', -- abstract_p - null, -- type_extension_table - null -- name_method - ); - end if; - - return 0; -end;' language 'plpgsql'; - -select inline_0 (); - -drop function inline_0 (); +-- +-- packages/ams/sql/postgresql/telecom-number-missing-plsql.sql +-- +-- @author Matthew Geddert openacs@geddert.com +-- @creation-date 2004-09-07 +-- @cvs-id $Id$ +-- +-- + +-- +-- This file can safely be deleted once telecom number fixes a bug #2099 +-- I filed that has this code commented out +-- + +create function inline_0 () +returns integer as ' +declare + v_telecom_number_p boolean; +begin + v_telecom_number_p := ''1'' from acs_object_types where object_type = ''telecom_number''; + + if v_telecom_number_p then + else + PERFORM acs_object_type__create_type ( + ''telecom_number'', -- object_type + ''Telecom Number'', -- pretty_name + ''Telecom Number'', -- pretty_plural + ''acs_object'', -- supertype + ''telecom_numbers'', -- table_name + ''number_id'', -- id_column + ''telecom_number'', -- package_name + ''f'', -- abstract_p + null, -- type_extension_table + null -- name_method + ); + end if; + + return 0; +end;' language 'plpgsql'; + +select inline_0 (); + +drop function inline_0 ();