From: | "Julie May" <julie(at)ccorb(dot)com> |
---|---|
To: | "Andre Felipe Machado" <andremachado(at)techforce(dot)com(dot)br>, <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Re: large objects and pg 7.3.x |
Date: | 2003-08-19 23:25:51 |
Message-ID: | 018701c366a9$3aea84e0$a1d2a8c0@impsu.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)techforce(dot)com(dot)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>
From | Date | Subject | |
---|---|---|---|
Next Message | Andre Felipe Machado | 2003-08-20 11:23:08 | Re: large objects and pg 7.3.x |
Previous Message | Andre Felipe Machado | 2003-08-19 15:16:02 | Re: large objects and pg 7.3.x |