Index: openacs-4/packages/photo-album/sql/postgresql/pl-pgsql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/sql/postgresql/pl-pgsql.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/photo-album/sql/postgresql/pl-pgsql.sql	12 Jun 2003 06:55:45 -0000	1.2
+++ openacs-4/packages/photo-album/sql/postgresql/pl-pgsql.sql	16 Jun 2003 12:59:00 -0000	1.3
@@ -20,9 +20,9 @@
 --  creates new pa_photo
 --  associated pa_images must be created by calling script
 */
--- drop function pa_photo__new (varchar,integer,integer,integer,timestamp, integer, varchar, varchar, integer, varchar, varchar, boolean, timestamp, varchar, varchar, text);
+-- drop function pa_photo__new (varchar,integer,integer,integer,timestamptz, integer, varchar, varchar, integer, varchar, varchar, boolean, timestamptz, varchar, varchar, text);
 
-create or replace function pa_photo__new (varchar,integer,integer,integer,timestamp, integer, varchar, varchar, integer, varchar, varchar, boolean, timestamp, varchar, varchar, text
+create or replace function pa_photo__new (varchar,integer,integer,integer,timestamptz, integer, varchar, varchar, integer, varchar, varchar, boolean, timestamptz, varchar, varchar, text
   ) returns integer as '
   declare 
     new__name		alias for $1;
@@ -145,9 +145,9 @@
 /*
 -- Creates a new pa_album
 */
--- drop function pa_album__new (varchar, integer, integer, boolean, integer, varchar, varchar, varchar, text, integer, timestamp, varchar, integer, timestamp, varchar);
+-- drop function pa_album__new (varchar, integer, integer, boolean, integer, varchar, varchar, varchar, text, integer, timestamptz, varchar, integer, timestamptz, varchar);
 
-create or replace function pa_album__new (varchar, integer, integer, boolean, integer, varchar, varchar, varchar, text, varchar, integer, timestamp, varchar, integer, timestamp, varchar) 
+create or replace function pa_album__new (varchar, integer, integer, boolean, integer, varchar, varchar, varchar, text, varchar, integer, timestamptz, varchar, integer, timestamptz, varchar) 
 returns integer as '
   declare
     new__name		alias for $1;
Index: openacs-4/packages/photo-album/sql/postgresql/upgrade/upgrade-4.5-4.6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/sql/postgresql/upgrade/upgrade-4.5-4.6.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/photo-album/sql/postgresql/upgrade/upgrade-4.5-4.6.sql	16 Jun 2003 12:59:01 -0000	1.1
@@ -0,0 +1,3 @@
+-- just reload plpgsql file to change timestamp params to timestamptz
+
+\i ../pl-pgsql.sql
\ No newline at end of file