Re: large objects and pg 7.3.x
От | Andre Felipe Machado |
---|---|
Тема | Re: large objects and pg 7.3.x |
Дата | |
Msg-id | 200308190745.10820.andremachado@techforce.com.br обсуждение исходный текст |
Ответ на | Re: large objects and pg 7.3.x (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: large objects and pg 7.3.x
|
Список | pgsql-odbc |
Hello, Many thanks for your answer. > > I think this is just a matter of obsolete documentation --- if you can > point to where it still says to use a CREATE TYPE hack, we can fix it. http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52 > The easy way to define "lo" now is just as a domain over oid: > CREATE DOMAIN lo AS oid; I already tested this idea before contacting the list. Unfortunately it does not work also. At least from OpenOffice 1.1rc2 connected by psqlodbc or unixodbc. Also without success, tested the idea from Hiroshi Saito (http://archives.postgresql.org/pgadmin-hackers/2003-06/msg00359.php ) Both suggestions did not work. Using postgresql-contrib "lo", I was able to insert and extract images using sql commands from inside psql. When inserted this way, psqlodbc can DISPLAY images at OpenOffice.org forms. But can not insert new ones. > > However, if you want the cleanup semantics that the contrib package > offers, by all means use it instead. I don't believe ODBC should care > which way you've defined "lo". > > regards, tom lane Please, could you give some guidance, or point to some psqlodbc devel documentation in order to modify the code? I have very limited desktop programming coding skill , but will try to get it working, without disrupting whole code. The contrib lo cleanup code seems to be context sensitive, adapting to the variable details. The contrib lo definition does not use "passedbyvalue", but use a pointer instead. It uses variable length output too. Regards. Andre Felipe
В списке pgsql-odbc по дате отправления: