Index: openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql,v diff -u -r1.12 -r1.12.2.1 --- openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql 25 Sep 2006 20:57:34 -0000 1.12 +++ openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql 1 Jan 2007 11:47:01 -0000 1.12.2.1 @@ -193,6 +193,7 @@ returns char as ' declare repository_id alias for $1; + v_expiry_date acs_reference_repositories.expiry_date%TYPE; begin select expiry_date into v_expiry_date from acs_reference_repositories