Re: FOR SHARE vs FOR UPDATE locks

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas ADI SD
Тема Re: FOR SHARE vs FOR UPDATE locks
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579018FE8F2@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: FOR SHARE vs FOR UPDATE locks  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> > I'm not sure we can use the simple "raise an ERROR" answer though,
> > because for users that would be a regression.
>
> I've reconsidered the idea of upgrading the outer xact's shared lock
to
> exclusive: at first I thought that would be hard to implement
correctly,
> but now I realize it's easy.  Just re-use the XID that's in the
multixact
> as the one to store as the exclusive locker, instead of storing our
> current subxact XID.  In some cases this will be a subcommitted XID of
> the current subxact or a parent, but the locking semantics are the
same,
> and even though we think such an XID is finished everyone else will
see
> it as still live so the appearance of its XID in an XMAX field
shouldn't
> be an issue.

fwiw, I think that is good.

Andreas


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: small pg_dump RFE: new --no-prompt (password) option
Следующее
От: Leandro Lucarella
Дата:
Сообщение: Re: Keep-alive support