2013/8/21 Jim Nasby <jim(at)nasby(dot)net>
> On 8/12/13 1:08 PM, Pavel Stehule wrote:
>
>> IF (bytes != LENGTH($1)) THEN
>> RAISE EXCEPTION 'Not all data copied to blob';
>> END IF;
>> PERFORM lo_close(fd);
>>
>
> FWIW, it's probably better to close before raising the exception...
>
it should to be done automatically - lo handler is released after
transaction end
Pavel
> --
> Jim C. Nasby, Data Architect jim(at)nasby(dot)net
> 512.569.9461 (cell) http://jim.nasby.net
>