Re: Test for trigger condition accessing system attributes - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Test for trigger condition accessing system attributes
Date
Msg-id 16d84c11-3dd9-c13d-1692-85ada401f05a@iki.fi
Whole thread Raw
In response to Test for trigger condition accessing system attributes  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
Responses Re: Test for trigger condition accessing system attributes  (Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>)
List pgsql-hackers
On 10/05/18 11:58, Ashutosh Bapat wrote:
> Hi,
> I was investigating the cases when the system attributes are accessed
> beyond the scans. After investigating set_plan_references(), I thought
> that we never access system attributes beyond scans. This lead me to
> assume that EEOP_INNER/OUTER_SYSVAR are not needed since we do not
> access system attributes from an inner or outer slot. I removed the
> defintions and code using those and ran regression. All the tests
> passed. So, I was about to conclude that my assumption is correct. But
> then looking at TriggerEnabled() I realised that we also (ab?)use
> INNER/OUTER Vars for OLD/NEW tuples for trigger condition. If the WHEN
> condition in CREATE TRIGGER command refers to a system attribute, we
> will end up having INNER/OUTER var refering a system attribute, thus
> exercising code for EEOP_INNER/OUTER_SYSVAR.
> 
> Here's patch containing a testcase exercizing that code using
> EEOP_INNER/OUTER_SYSVAR.

Pushed with some small changes. Thanks!

- Heikki


pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: [PATCH] Add support for ON UPDATE/DELETE actions on ALTER CONSTRAINT
Next
From: Ashutosh Bapat
Date:
Subject: Re: Test for trigger condition accessing system attributes