2013/8/21 Jim Nasby <j...@nasby.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 j...@nasby.net > 512.569.9461 (cell) http://jim.nasby.net >
