Thread: lo function changed in PostgreSQL 8.1.1 (ask again)

From contrib/lo I found that it has something  difference between old and new version of PostgreSQL.  And I'm sure that I already tick on Large Object (lo) option when I install.

 

How can I manage on difference function?

 

 

 

:::New Version:::

DOMAIN lo AS pg_catalog.oid;

 

FUNCTION lo_oid(lo) RETURNS pg_catalog.oid AS 'SELECT $1::pg_catalog.oid' LANGUAGE SQL STRICT IMMUTABLE;

 

FUNCTION lo_manage() RETURNS pg_catalog.trigger AS '$libdir/lo' LANGUAGE C;

 

 

 

 

FUNCTION lo_in(cstring) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;

 

FUNCTION lo_out(lo) RETURNS cstring AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;

 

TYPE lo (  INTERNALLENGTH = 4, EXTERNALLENGTH = variable, INPUT = lo_in, OUTPUT = lo_out);

 

FUNCTION lo_oid(lo) RETURNS oid AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;

 

FUNCTION oid(lo) RETURNS oid AS '$libdir/lo', 'lo_oid' LANGUAGE C IMMUTABLE STRICT;

 

CAST (lo as oid) WITH FUNCTION oid(lo) AS IMPLICIT;

 

FUNCTION lo(oid) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT;

 

CAST (oid as lo) WITH FUNCTION lo(oid) AS IMPLICIT;

 

FUNCTION lo_manage() RETURNS trigger AS '$libdir/lo' LANGUAGE C;