From: | Patrick Welche <prlw1(at)newn(dot)cam(dot)ac(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: "lo" large object |
Date: | 2002-09-25 21:56:44 |
Message-ID: | 20020925225644.A10728@quartz.newn.cam.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)newn(dot)cam(dot)ac(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Patrick Welche | 2002-09-25 22:13:16 | Re: Relation 0 does not exist |
Previous Message | Tom Lane | 2002-09-25 21:49:17 | Re: Relation 0 does not exist |