Re: Statement-level Triggers For Uniqueness Checks

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Statement-level Triggers For Uniqueness Checks
Date: 2019-01-04 12:48:57
Message-ID: 3f6792a4-adc0-5b57-11c2-a85f9094ac6e@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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).

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Michael Paquier 2019-01-04 12:49:52 Re: Allow auto_explain to log to NOTICE
Previous Message David Rowley 2019-01-04 12:38:31 Re: Using POPCNT and other advanced bit manipulation instructions