Re: [PDO] Mapping data type/size

On 02.11.2009, at 09:51, Lester Caine wrote:

> Lester Caine wrote:
>> Please bare with me ... I'm still trying to 'convert' from my  
>> normal way of working ;)
>
> http://old.nabble.com/PostgreSQL-support:-BYTEA-trouble- 
> td25879589.html
>
> So it looks like even PostgreSQL has problems with 'streams' default  
> in PDO ;)


well some of the issues are "home grown" on the postgresql side. afaik  
postgresql dropped their old clob/blob type because it has security  
issues. they have not added streaming support for bytea IIRC .. so at  
the moment the streaming support seems superflous, while once they add  
streaming support again .. it could be quitwe empowering when dealing  
with large data sets (which is what clob/blob is meant for).

anyways .. i did not quite get the comment "Why does PDO return BYTEA  
fields as streams while returning BLOB
fields as strings?" .. afaik PDO does return a stream for BLOB fields  
with PostgreSQL ... but i havent verified it.

anyways .. i think making it possible to choose between a string and a  
stream seems to be a sensible feature to add.

regards,
Lukas Kahwe Smith
[email protected]