Index: openacs-4/packages/static-portlet/sql/postgresql/static-core.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/static-portlet/sql/postgresql/static-core.sql,v diff -u -N -r1.3.2.1 -r1.3.2.2 --- openacs-4/packages/static-portlet/sql/postgresql/static-core.sql 2 Mar 2003 22:40:20 -0000 1.3.2.1 +++ openacs-4/packages/static-portlet/sql/postgresql/static-core.sql 30 Jul 2003 22:16:02 -0000 1.3.2.2 @@ -70,7 +70,7 @@ pretty_name varchar(100) constraint static_p_c_pretty_name_nn not null, - content varchar(4000) + body text ); @@ -79,6 +79,10 @@ -- API -- +-- content is still a varchar, even though it is being used to put content +-- into body, a clob, because a varchar is what's being passed in from the +-- Tcl script. + create function static_portal_content_item__new (integer, varchar, varchar) returns integer as ' declare @@ -139,7 +143,7 @@ insert into static_portal_content - (content_id, package_id, pretty_name, content) + (content_id, package_id, pretty_name, body) values (v_content_id, p_package_id, p_pretty_name, p_content);