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 -N -r1.7 -r1.8
--- openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql	2 Sep 2001 17:06:29 -0000	1.7
+++ openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql	17 May 2003 09:55:32 -0000	1.8
@@ -48,13 +48,13 @@
     package_name	varchar(100)
 			constraint arr_package_name_uq unique,
     -- last updated
-    last_update		timestamp,
+    last_update		timestamptz,
     -- where is this data from
     source		varchar(1000),
     source_url		varchar(255),
     -- should default to today
-    effective_date	timestamp, -- default sysdate
-    expiry_date		timestamp,
+    effective_date	timestamptz, -- default sysdate
+    expiry_date		timestamptz,
     -- a text field to hold the maintainer
     maintainer_id	integer
 			constraint arr_maintainer_id_fk references persons(person_id),
@@ -69,9 +69,9 @@
 
 -- default for Oracle
 
-create function acs_reference__new (integer,varchar,boolean,varchar,timestamp,
-varchar,varchar,timestamp,timestamp,integer,integer,varchar,varchar,
-integer,varchar,integer)
+create function acs_reference__new (integer,varchar,boolean,varchar,timestamptz,
+varchar,varchar,timestamptz,timestamptz,integer,integer,varchar,varchar,
+varchar,varchar,integer)
 returns integer as '
 declare
     p_repository_id   alias for $1; -- default null
@@ -150,8 +150,8 @@
 ' language 'plpgsql';
 
 -- made initially for PG 
-create function acs_reference__new (varchar,timestamp,
-varchar,varchar,timestamp)
+create function acs_reference__new (varchar,timestamptz,
+varchar,varchar,timestamptz)
 returns integer as '
 declare
     p_table_name      alias for $1; -- 
@@ -167,6 +167,7 @@
 end;
 ' language 'plpgsql';
 
+
 create function acs_reference__delete (integer)
 returns integer as '
 declare
