Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
[no subject]
DOMAIN lo AS pg_catalog.oid; =20 FUNCTION lo_oid(lo) RETURNS pg_catalog.oid AS 'SELECT $1::pg_catalog.oid' = LANGUAGE SQL STRICT IMMUTABLE; =20 FUNCTION lo_manage() RETURNS pg_catalog.trigger AS '$libdir/lo' LANGUAGE = C; =20 =20 =20 =20 :::Old Version::: =20 FUNCTION lo_in(cstring) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE = STRICT; =20 FUNCTION lo_out(lo) RETURNS cstring AS '$libdir/lo' LANGUAGE C IMMUTABLE = STRICT; =20 TYPE lo ( INTERNALLENGTH =3D 4, EXTERNALLENGTH =3D variable, INPUT =3D = lo_in, OUTPUT =3D lo_out); =20 FUNCTION lo_oid(lo) RETURNS oid AS '$libdir/lo' LANGUAGE C IMMUTABLE = STRICT; =20 FUNCTION oid(lo) RETURNS oid AS '$libdir/lo', 'lo_oid' LANGUAGE C = IMMUTABLE STRICT; =20 CAST (lo as oid) WITH FUNCTION oid(lo) AS IMPLICIT; =20 FUNCTION lo(oid) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE STRICT; =20 CAST (oid as lo) WITH FUNCTION lo(oid) AS IMPLICIT; =20 FUNCTION lo_manage() RETURNS trigger AS '$libdir/lo' LANGUAGE C; >>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 12/14/2005 22:06:33 >>> "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th> 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 --=__Part0725EE01.1__= Content-Type: text/html; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Description: HTML <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-874= "> <META content=3D"MSHTML 6.00.2900.2802" name=3DGENERATOR></HEAD> <BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Microsoft Sans Serif"> <DIV>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.</DIV> <DIV> </DIV> <DIV>How can I manage on difference function?</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV>:::New Version:::</DIV> <DIV><BR>DOMAIN lo AS pg_catalog.oid;</DIV> <DIV> </DIV> <DIV>FUNCTION lo_oid(lo) RETURNS pg_catalog.oid AS 'SELECT $1::pg_catalog.o= id' LANGUAGE SQL STRICT IMMUTABLE;</DIV> <DIV> </DIV> <DIV>FUNCTION lo_manage() RETURNS pg_catalog.trigger AS '$libdir/lo' = LANGUAGE C;</DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> </DIV> <DIV> <DIV>:::Old Version:::</DIV> <DIV> </DIV></DIV> <DIV>FUNCTION lo_in(cstring) RETURNS lo AS '$libdir/lo' LANGUAGE C = IMMUTABLE STRICT;</DIV> <DIV> </DIV> <DIV>FUNCTION lo_out(lo) RETURNS cstring AS '$libdir/lo' LANGUAGE C = IMMUTABLE STRICT;</DIV> <DIV> </DIV> <DIV>TYPE lo ( INTERNALLENGTH =3D 4, EXTERNALLENGTH =3D variable, = INPUT =3D lo_in, OUTPUT =3D lo_out);</DIV> <DIV> </DIV> <DIV>FUNCTION lo_oid(lo) RETURNS oid AS '$libdir/lo' LANGUAGE C IMMUTABLE = STRICT;</DIV> <DIV> </DIV> <DIV>FUNCTION oid(lo) RETURNS oid AS '$libdir/lo', 'lo_oid' LANGUAGE C = IMMUTABLE STRICT;</DIV> <DIV> </DIV> <DIV>CAST (lo as oid) WITH FUNCTION oid(lo) AS IMPLICIT;</DIV> <DIV> </DIV> <DIV>FUNCTION lo(oid) RETURNS lo AS '$libdir/lo' LANGUAGE C IMMUTABLE = STRICT;</DIV> <DIV> </DIV> <DIV>CAST (oid as lo) WITH FUNCTION lo(oid) AS IMPLICIT;</DIV> <DIV> </DIV> <DIV>FUNCTION lo_manage() RETURNS trigger AS '$libdir/lo' LANGUAGE = C;<BR><BR><BR>>>> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 12/14/2005 = 22:06:33 >>><BR>"Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th&g= t; writes:<BR>> I think I use contrib/lo type for manage lo. What = is wrong?<BR><BR>You need to use the 8.1 version of contrib/lo, not any = previous version.<BR><BR>You might find that the easiest way to manage = this is to create an empty<BR>database, load the 8.1 contrib/lo definitions= by running lo.sql, then<BR>restoring from your pg_dump backup. = You'll see some complaints about<BR>duplicate function definitions but = these can be ignored.<BR><BR>regards, tom lane<BR></DIV></BODY></HTML> --=__Part0725EE01.1__=--
- Prev by Date: [no subject]
- Next by Date: [no subject]
- Previous by thread: [no subject]
- Next by thread: [no subject]
- Indexes: