Skip site navigation (1) Skip section navigation (2)

Re: BLOB issue(s) & questions

From: Andre Felipe Machado <andremachado(at)techforce(dot)com(dot)br>
To: "pgsql-odbc" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: BLOB issue(s) & questions
Date: 2004-05-16 12:45:01
Message-ID: (view raw or whole thread)
Lists: pgsql-odbc
> There are three options:
> 1) Use a bytea column. You might create a domain as an 'lo' alias to
> bytea if required.

This works. And very easy.
But for files upt to around 2 MB. Beware.

> 2) Use the /contrib/lo code. This custom datatype allows you to create a
> cleanup trigger for each lo column.

This works.
but not easy with odbc and other apps...

> 3) Use the 'simple' ODBC lo option documented at:
> -

> Please note that I haven't tried using blobs in years...
> Regards, Dave.

Solution 3 does not work for Postgresql since 7.x, as I can remember. For 
7.3.x is sure (I tried).
The innards of Pg changed a lot and it does not allow the tricks cited.
Use the solution 2, instead, for very large objects over 2MB.

good luck.
Andre Felipe

In response to

pgsql-odbc by date

Next:From: Nicola TilingDate: 2004-05-17 10:11:45
Subject: ODBC Driver Options
Previous:From: Yury KolesDate: 2004-05-16 07:00:48
Subject: Re: psqlODBC driver does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group