Index: openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql,v
diff -u -r1.35 -r1.36
--- openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql	17 Mar 2004 15:29:08 -0000	1.35
+++ openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql	24 Jul 2004 14:44:55 -0000	1.36
@@ -265,28 +265,28 @@
 end;' language 'plpgsql' stable strict;
 
 create view acs_func_defs as 
-select get_func_definition(proname,proargtypes) as definition, 
+select get_func_definition(proname::varchar,proargtypes) as definition, 
        proname as fname 
   from pg_proc;
 
 create view acs_func_headers as 
-select get_func_header(proname,proargtypes) as definition, 
+select get_func_header(proname::varchar,proargtypes) as definition, 
        proname as fname 
   from pg_proc;
 
 ----------------------------------------------------------------------------
 
 create function inline_0 () returns integer as '
 -- Create a bitfromint4(integer) function if it doesn''t exists.
--- Due to a bug in PG 7.3 this function is absent in PG 7.3.
+-- This function is no longer present in 7.3 and above
 declare
     v_bitfromint4_count integer;
 begin
     select into v_bitfromint4_count count(*) from pg_proc where proname = ''bitfromint4'';
     if v_bitfromint4_count = 0 then
 	create or replace function bitfromint4 (integer) returns bit varying as ''
 	begin 
-    	    return "bit"($1);
+    	    return $1::bit(32);
 	end;'' language ''plpgsql'' immutable strict;
    end if;
    return 1;
@@ -297,7 +297,7 @@
 
 create function inline_1 () returns integer as '
 -- Create a bitfromint4(integer) function if it doesn''t exists.
--- Due to a bug in PG 7.3 this function is absent in PG 7.3.
+-- This function is no longer present in 7.3 and above
 declare
     v_bittoint4_count integer;
 begin
