[Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC] - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
Date
Msg-id 36F902CC.3FE1EF8B@insightdist.com
Whole thread Raw
List pgsql-interfaces



Sam O'Connor wrote:

> I have attached the logs.
> Thankyou very much for your help.
>
> Sam O'Connor
>
>

I don't really see the problem.  It seems more like there is something wrong on the postgres side.

create type lo (internallength=4,externallength=10,input=int4in,output=int4out,
                default='',passedbyvalue);

If this is what you typed in to create the "lo" type, then it should work.  Try inserting a row manually into the
table,say something like: 

insert into image ( 1, 2, 'stuff', 5);

If this fails, then maybe there is something weird with the i/o routines (int4in, int4out), in which case, you should
seekmore help from perhaps the "general" 
mailing list.

Byron



pgsql-interfaces by date:

Previous
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Problem using Having in a sub-query wit the Count function.
Next
From: Byron Nikolaidis
Date:
Subject: Resignation