Interestingly, this is the latest tsearch2 function that ships with 8.0.3 - note the slightly different syntax to the one below. It looks like the compatibility issue is caused by this. I shall try and modify the function in the 8.0.1 database, then try and restore it to a 8.0.3 server and see what happens!

Howard Cole
www.selestial.com


CREATE OR REPLACE FUNCTION dex_init(internal)
 RETURNS internal AS
'$libdir/tsearch2', 'dex_init'
 LANGUAGE 'c' VOLATILE;
ALTER FUNCTION dex_init(internal) OWNER TO postgres;


Howard Cole wrote:


   CREATE OR REPLACE FUNCTION dex_init(text)
     RETURNS internal AS
   '$libdir/tsearch2', 'dex_init'
     LANGUAGE 'c' VOLATILE;
   ALTER FUNCTION dex_init(text) OWNER TO postgres;


Is it possible to change that function to be compatible with both 8.0.1 and 8.0.3 - or am I looking in the wrong place?






---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to