Postgres Pro
Downloads
Home   >   mailing lists

Re: proposal: lob conversion functionality - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: proposal: lob conversion functionality
Date
Msg-id 52153374.4030207@nasby.net
Whole thread Raw
In response to Re: proposal: lob conversion functionality  (Pavel Stehule <pavel.stehule@gmail.com>)
Responses Re: proposal: lob conversion functionality  (Pavel Stehule <pavel.stehule@gmail.com>)
List pgsql-hackers
Tree view 
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...
-- 
Jim C. Nasby, Data Architect                       jim@nasby.net
512.569.9461 (cell)                         http://jim.nasby.net

pgsql-hackers by date:

Previous
From: Jim Nasby
Date:
Subject: Re: System catalog vacuum issues
Next
From: Jim Nasby
Date:
Subject: Re: HeapTupleSatisfiesDirty fails to test HEAP_XMAX_IS_LOCKED_ONLY for TransactionIdIsInProgress(...)