Re: JDBC and Blobs

Поиск
Список
Период
Сортировка
От Albe Laurenz
Тема Re: JDBC and Blobs
Дата
Msg-id D960CB61B694CF459DCFB4B0128514C2023A99F2@exadv11.host.magwien.gv.at
обсуждение исходный текст
Ответ на JDBC and Blobs  (Dev <dev_hyd2001@yahoo.com>)
Ответы Re: JDBC and Blobs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
Dev wrote:
> I have a field in my database table of type OID which is
> suppose to be used to store binary data. I plan on using the
> setBlob and getBlob methods for storing and retrieving
> entries from the table. Is that the right way to proceed? If
> I delete a row in that table , will it delete the binary data
> as well from the database server?

No; the best way would be to create a trigger on the table that
will delete the large object if you delete (or change) the
OID in the table row.

This is of course only practical if the same large object
is not referenced by more than one table...

Yours,
Laurenz Albe

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Craig Ringer
Дата:
Сообщение: Re: JDBC and Blobs
Следующее
От: Tom Lane
Дата:
Сообщение: Re: JDBC and Blobs