Re: Statement-level Triggers For Uniqueness Checks

Поиск
Список
Период
Сортировка
От Corey Huinker
Тема Re: Statement-level Triggers For Uniqueness Checks
Дата
Msg-id CADkLM=fskf3o2HuYYKOkyebvbqrz+BbxHH1JLq7yac1T2xOKAA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Statement-level Triggers For Uniqueness Checks  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: Statement-level Triggers For Uniqueness Checks  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Список pgsql-hackers
On Fri, Jan 4, 2019 at 7:49 AM Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:
>
> On 25/12/2018 00:56, Corey Huinker wrote:
> > The regression diff (attached) seems to imply that the triggers simply
> > are not firing, though.
>
> The reason for this was explained by Dean.  If you take out the check
> that he mentioned, then your trigger fires but crashes.  In your changed
> unique_key_recheck(), "slot" is not initialized before use (or ever).

Thanks. I'll be revisiting this shortly. Dean's information made me
think the potential for a gain is smaller than initially imagined.


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

Предыдущее
От: John Naylor
Дата:
Сообщение: Re: reducing the footprint of ScanKeyword (was Re: Large writable variables)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: reducing the footprint of ScanKeyword (was Re: Large writable variables)