Re: Backup Compatibility between minor versions. - Mailing list pgsql-general

From Howard Cole
Subject Re: Backup Compatibility between minor versions.
Date
Msg-id 42A80F79.4010100@selestial.com
Whole thread Raw
In response to Re: Backup Compatibility between minor versions.  (Howard Cole <howardnews@selestial.com>)
Responses Re: Backup Compatibility between minor versions.
List pgsql-general
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?
>
>
>
>


pgsql-general by date:

Previous
From: Marco Colombo
Date:
Subject: Re: vulnerability/SSL
Next
From: Sean Davis
Date:
Subject: Re: postgres and ggobi/xgvis