Re: BLOB issue(s) & questions

> -----Original Message-----
> From: Derek Shaw [mailto:derek(at)bisi(dot)ca]
> Sent: 09 February 2004 20:30
> To: pgsql-odbc
> Subject: [ODBC] BLOB issue(s) & questions
>
> Can anyone shed any light on how serious this problem is,
> what the problem actually might be, and whether it is ever
> likely to be resolved so that I could use PostgreSQL?

Hi Derek,

There are three options:

1) Use a bytea column. You might create a domain as an 'lo' alias to
bytea if required.

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

3) Use the 'simple' ODBC lo option documented at:
http://gborg.postgresql.org/project/psqlodbc/faq/faq.php?faq_id=52 -
this does not cleanup after itself, however in /contrib/vacuumlo is a
small utility that will remove orphaned large objects - just run it
prior to a normal vacuum, or at whatever frequency suits if you use the
autovacuum daemon.

Please note that I haven't tried using blobs in years...

Regards, Dave.