Message-Id: <36F902CC.3FE1EF8B@insightdist.com>
Date: Wed, 24 Mar 1999 10:20:44 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
Mime-Version: 1.0
To: "pgsql-interfaces@hub.org" <pgsql-interfaces@hub.org>
Subject: [Fwd: [INTERFACES] type error inserting large obj, Win32 ODBC]
Content-Type: multipart/mixed; boundary="------------C2CA35DE7AE8AC2B6B8140A9"

This is a multi-part message in MIME format.
--------------C2CA35DE7AE8AC2B6B8140A9
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


--------------C2CA35DE7AE8AC2B6B8140A9
Content-Type: message/rfc822
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Message-ID: <36F8F7B8.4A396607@insightdist.com>
Date: Wed, 24 Mar 1999 09:33:28 -0500
From: Byron Nikolaidis <byronn@insightdist.com>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
To: Sam@OConnor.net
Subject: Re: [INTERFACES] type error inserting large obj, Win32 ODBC
References: <36F5C26E.49702D13@netspace.net.au>
	<36F679B8.CF2B577C@insightdist.com>
	<36F8E290.73F534CF@netspace.net.au>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit


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 seek more help from perhaps the "general"
mailing list.

Byron


--------------C2CA35DE7AE8AC2B6B8140A9--