| From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
|---|---|
| To: | Jim Nasby <jim(at)nasby(dot)net> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: proposal: lob conversion functionality |
| Date: | 2013-08-22 06:14:42 |
| Message-ID: | CAFj8pRDPb_47OxSW3EOL7idRWDs4n=WuVimn8nUhB9TagKj5iA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-08-22 06:15:26 | Re: CAST Within EXCLUSION constraint |
| Previous Message | Tom Lane | 2013-08-22 06:13:05 | Re: docbook-xsl version for release builds |