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.13
--- 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	2 Jan 2007 09:53:43 -0000	1.13
@@ -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