Index: openacs-4/packages/logger/sql/postgresql/logger-tables-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/logger/sql/postgresql/logger-tables-drop.sql,v diff -u -r1.2 -r1.3 --- openacs-4/packages/logger/sql/postgresql/logger-tables-drop.sql 25 Apr 2003 09:45:49 -0000 1.2 +++ openacs-4/packages/logger/sql/postgresql/logger-tables-drop.sql 7 May 2003 16:43:32 -0000 1.3 @@ -1,12 +1,13 @@ -- Drop non-procedural data model of the Logger application. +-- -- NOTE: In general it is not a good idea to source sql drop scripts -- from the command line since such scripts may assume that any data in package instances -- has already been dropped by the APM through the before-uninstantiate callback. -- Use the /acs-admin/apm UI instead to delete packages. -- -- @author Lars Pind (lars@collaboraid.biz) -- @author Peter Marklund (peter@collaboraid.biz) --- @creation-date 3:d of April 2003 +-- @creation-date 2003-05-07 drop table logger_entries; @@ -30,8 +31,18 @@ drop table logger_variables; -drop sequence logger_variables_seq; +create function inline_0 () +returns integer as ' +begin + perform acs_object_type__drop_type ( + ''logger_variable'', ''f'' + ); + return null; +end;' language 'plpgsql'; +select inline_0(); +drop function inline_0 (); + drop table logger_project_pkg_map; drop table logger_projects; @@ -47,4 +58,3 @@ end;' language 'plpgsql'; select inline_0(); drop function inline_0 (); -