"lo" large object
Just got stuck in the v7.2->v7.3 load:
4672: ERROR: TypeCreate: function int4out(lo) does not exist
lo being the type to keep psqlodbc happy when importing M$ access files. The
old definition was:
--
-- TOC entry 2 (OID 229586)
-- Name: lo; Type: TYPE; Schema: ; Owner: prlw1
--
CREATE TYPE lo (
INTERNALLENGTH = 4,
INPUT = int4in,
OUTPUT = int4out,
DEFAULT = '',
ALIGNMENT = int4,
STORAGE = plain,
PASSEDBYVALUE
);
Suggestions? (Is my lo defn out of date, or maybe psqlodbc?)
Cheers,
Patrick
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
lo being the type to keep psqlodbc happy when importing M$ access files. The
old definition was:
CREATE TYPE lo (
INTERNALLENGTH = 4,
INPUT = int4in,
OUTPUT = int4out,
Hm. The system doesn't tolerate type cheats like that anymore
(and the code was wrong anyway, since it should've been using
oidin/oidout).
I guess we'll have to fix the contrib/lo module. Thanks for the
report...
regards, tom lane
On Wed, Sep 25, 2002 at 04:11:24PM -0400, Tom Lane wrote:
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
lo being the type to keep psqlodbc happy when importing M$ access files. The
old definition was:CREATE TYPE lo (
INTERNALLENGTH = 4,
INPUT = int4in,
OUTPUT = int4out,Hm. The system doesn't tolerate type cheats like that anymore
(and the code was wrong anyway, since it should've been using
oidin/oidout).I guess we'll have to fix the contrib/lo module. Thanks for the
report...
I didn't know about contrib/lo - the above was in a FAQ - I think where
you get the psqlodbc driver from..
Cheers,
Patrick
On Wed, Sep 25, 2002 at 09:26:10PM +0100, Patrick Welche wrote:
On Wed, Sep 25, 2002 at 04:11:24PM -0400, Tom Lane wrote:
Patrick Welche <prlw1@newn.cam.ac.uk> writes:
lo being the type to keep psqlodbc happy when importing M$ access files. The
old definition was:CREATE TYPE lo (
INTERNALLENGTH = 4,
INPUT = int4in,
OUTPUT = int4out,Hm. The system doesn't tolerate type cheats like that anymore
(and the code was wrong anyway, since it should've been using
oidin/oidout).I guess we'll have to fix the contrib/lo module. Thanks for the
report...I didn't know about contrib/lo - the above was in a FAQ - I think where
you get the psqlodbc driver from..
And contrib/lo works :-)
patrimoine=# \i lo.sql
psql:lo.sql:14: WARNING: ProcedureCreate: type lo is not yet defined
CREATE FUNCTION
psql:lo.sql:20: WARNING: Argument type "lo" is only a shell
CREATE FUNCTION
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
and OpenOffice/Data sources -> odbc -> patrimoine worked.
Thanks,
Patrick