[fpc-devel] PostgreSQL 8.4.5 Ubuntu 10.10 x64 and bytea=blobs up to 1 gigabyte

[Michael Van Canneyt]

On Fri, 22 Oct 2010, Andrew Brunner wrote:

> Looking to get some resolution to an immediate problem with postgres
> component I have...
>
> Field definitions for blob can be mapped to bytea and enable support
> for blob data as I am pretty sure byte for byte output/input would
> suffice.  Some debugging may be needed to make sure we don't need
> escape/unescape on string literals.  I'm hoping for a quick fix.

I committed a fix in 16203, please test.

>
> As is right now, the postgres DBMS system if offline limits b/c I
> happen to rely heavliy on Field/Paramter).AsBlob:=[] in my code for
> arrays[n] of Int64 where each element is 8 bytes long.  MySQL did this
> flawlessly.  What's it gonna take to remove the restriction and map
> the field to bytea?

Well, a 'please' usually does it in this part of the world.

Michael.