I am able to insert an image into postgresql using the psqlodbc driver. I
created the lo type using the files in the contrib directory. I was never
able to make the lo_manage() function work. Instead I created my own
functions and used triggers to execute them. I only needed the functions for
deleting and updating records. I haven't had any problems inserting. When
the lo type was created it should have created the following functions :
lo(oid)
lo_in(cstring)
lo_manage()
lo_oid(public.lo)
lo_out(public.lo)
oid(public.lo)
I hope that is somewhat helpfull.
Julie
<snip>
----- Original Message -----
From: "Andre Felipe Machado" <andremachado@techforce.com.br>
> The postgresql psql tool can insert an image (can also extracts it) using
> direct sql commands. And OpenOffice can display it at the form.
> When trying to save a new record, containing a new image, the program
> complains.
> The error message is reproduced at near the end of the attached sql log
file.
> I hope this help.
> Regards.
> Andre Felipe
</snip>