Re: large objects and pg 7.3.x

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>

In response to

Responses

Browse pgsql-odbc by date

  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