Re: Re: [PATCHES] Patch to support transactions with BLOBs for current CVS

Поиск
Список
Период
Сортировка
От Denis Perchine
Тема Re: Re: [PATCHES] Patch to support transactions with BLOBs for current CVS
Дата
Msg-id 01012113094601.00620@dyp.perchine.com
обсуждение исходный текст
Ответ на Re: Re: [PATCHES] Patch to support transactions with BLOBs for current CVS  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: Re: [PATCHES] Patch to support transactions with BLOBs for current CVS  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > First of all it will not break lo_creat, lo_unlink for sure.
>
> lo_creat depends on inv_create followed by inv_close; your patch
> proposed to disable both of those outside transaction blocks.
> lo_unlink depends on inv_drop, which ditto.  Your patch therefore
> restricts lo_creat and lo_unlink to be done inside transaction blocks,
> which is a new and completely unnecessary restriction that will
> doubtless break many existing applications.

OK.As I already said we can remove checks from inv_create/inv_drop. They are
not needed there.

> > But I do not see any reasons why we not put lo_import, and lo_export in
> > TX. At least this will prevent other backends from reading partially
> > imported BLOBs...
>
> lo_import and lo_export always execute in a transaction, just like any
> other backend operation.  There is no need to force them to be done in
> a transaction block.  If you're not clear about this, perhaps you need
> to review the difference between transactions and transaction blocks.

Hmmm... Where can I read about it? At least which source/header?

--
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Re: [PATCHES] Patch to support transactions with BLOBs for current CVS
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: BIT/BIT VARYING status