Index: openacs-4/packages/photo-album/sql/postgresql/photo-album-clip.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/photo-album/sql/postgresql/photo-album-clip.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/photo-album/sql/postgresql/photo-album-clip.sql	10 Jun 2003 10:06:19 -0000	1.1
+++ openacs-4/packages/photo-album/sql/postgresql/photo-album-clip.sql	12 Jun 2003 06:55:45 -0000	1.2
@@ -64,7 +64,7 @@
     );
 
 
-create function pa_collection__new (integer,integer,varchar,timestamp,integer,varchar,integer)
+create or replace function pa_collection__new (integer,integer,varchar,timestamp,integer,varchar,integer)
 returns integer as '
 declare
   p_collection_id                       alias for $1;       -- default null
@@ -100,7 +100,7 @@
 
 end;' language 'plpgsql';
 
-create function pa_collection__delete (integer)
+create or replace function pa_collection__delete (integer)
 returns integer as '
 declare
   p_collection_id                             alias for $1;
@@ -119,7 +119,7 @@
 end;' language 'plpgsql';
 
 
-create function pa_collection__title (integer)
+create or replace function pa_collection__title (integer)
 returns varchar as '
 declare
     p_collection_id        alias for $1;