PostgreSQL component does not support Blobs for inserting or updating records with streams
Original Reporter info from Mantis: aurawin
-
Reporter name: Andrew Brunner
Original Reporter info from Mantis: aurawin
- Reporter name: Andrew Brunner
Description:
I recently installed Postgres 8.4.5. While I realize that postgres does not namely support blobs it does support large (1gb) binary large object data arrays called (bytea). Blobs are indeed supported by postgres.
I need the TField to map blobs as native type bytea.
Steps to reproduce:
pseudo code:
------------------------------
Create field of bytea in postgres
insert sql parameter binding with some parameter[x] AsBlob:=#0#1#2#3#4
Query.Prepare (Currently crashes here with "Blob not yet supported"
Query.ExecSQL
------------------------------
select BLOB_FIELD from MyTable
MyDATA:=Query.Fields.FieldByName(BLOB_FIELD).AsBlob;
Mantis conversion info:
- Mantis ID: 17693
- OS: Ubuntu x64
- OS Build: 10.10
- Build: 16197
- Platform: Linux
- Version: 2.5.1
- Fixed in version: 2.4.4
- Fixed in revision: 16422 (#0379e000)
- Monitored by: » aurawin (Andrew Brunner)
- Target version: 3.0.0