Loading while open Large BLOB field, HOW ?

munggaran · Post by **munggaran** » Sat 11 Apr 2009 09:05

I have BLOB field about 15 Megs per field which want to be stored/retrieved via client/server application. My user wants :

1. Information on how much the stream has been stored/retrieved during the process (like progress bar, or something)
2. Cancel progress (in case the user feel the progress is too long, he can cancel the process)

Is that possible to do with postgreDAC ?

Regards,
Eldi Munggaran

Plash · Post by **Plash** » Mon 13 Apr 2009 07:39

Please specify whether your table has BYTEA field or OID field that references to a large object.

If you are using BYTEA, you can load data with the TPgLoader component. In its OnPutData event you can update a progress bar and check if the Cancel button was pressed.

dschuch · Post by **dschuch** » Sat 18 Apr 2009 13:27

but this should theoretically be possible with oid fields to, you send the BLOB in 64kb Block size nor?

Plash · Post by **Plash** » Mon 27 Apr 2009 07:19

TPgLoader uses COPY command to load data. This command can fill OID fields but it cannot create large objects.