Postgres Pro
Downloads
Home   >   mailing lists

Re: Statement-level Triggers For Uniqueness Checks - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Statement-level Triggers For Uniqueness Checks
Date
Msg-id 3f6792a4-adc0-5b57-11c2-a85f9094ac6e@2ndquadrant.com
Whole thread Raw
In response to Re: Statement-level Triggers For Uniqueness Checks  (Corey Huinker <corey.huinker@gmail.com>)
Responses Re: Statement-level Triggers For Uniqueness Checks  (Corey Huinker <corey.huinker@gmail.com>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: David Rowley
Date:
Subject: Re: Using POPCNT and other advanced bit manipulation instructions
Next
From: Michael Paquier
Date:
Subject: Re: Allow auto_explain to log to NOTICE