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;
:::Old Version:::
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;
>>> Tom Lane <[EMAIL PROTECTED]> 12/14/2005 22:06:33 >>> "Premsun Choltanwanich" <[EMAIL PROTECTED]> writes: > I think I use contrib/lo type for manage lo. What is wrong? You need to use the 8.1 version of contrib/lo, not any previous version. You might find that the easiest way to manage this is to create an empty database, load the 8.1 contrib/lo definitions by running lo.sql, then restoring from your pg_dump backup. You'll see some complaints about duplicate function definitions but these can be ignored. regards, tom lane |