Re: Allow WHEN in INSTEAD OF triggers

2020-01-06 Thread Dean Rasheed
On Sat, 28 Dec 2019 at 16:45, David Fetter wrote: > > On Sat, Dec 28, 2019 at 12:12:30AM -0300, Alvaro Herrera wrote: > > On 2019-Dec-28, David Fetter wrote: > > > > > While noodling around with an upcoming patch to remove user-modifiable > > > RULEs, I noticed that WHEN conditions were disallowed

Re: Allow WHEN in INSTEAD OF triggers

2019-12-28 Thread David Fetter
On Sat, Dec 28, 2019 at 12:12:30AM -0300, Alvaro Herrera wrote: > On 2019-Dec-28, David Fetter wrote: > > > While noodling around with an upcoming patch to remove user-modifiable > > RULEs, I noticed that WHEN conditions were disallowed from INSTEAD OF > > triggers for no discernible reason. This

Re: Allow WHEN in INSTEAD OF triggers

2019-12-28 Thread David Fetter
On Fri, Dec 27, 2019 at 10:29:15PM -0500, Tom Lane wrote: > David Fetter writes: > > While noodling around with an upcoming patch to remove user-modifiable > > RULEs, I noticed that WHEN conditions were disallowed from INSTEAD OF > > triggers for no discernible reason. This patch removes that > >

Re: Allow WHEN in INSTEAD OF triggers

2019-12-27 Thread Tom Lane
David Fetter writes: > While noodling around with an upcoming patch to remove user-modifiable > RULEs, I noticed that WHEN conditions were disallowed from INSTEAD OF > triggers for no discernible reason. This patch removes that > restriction. This seems like a remarkably bad idea. The point of a

Re: Allow WHEN in INSTEAD OF triggers

2019-12-27 Thread Alvaro Herrera
On 2019-Dec-28, David Fetter wrote: > While noodling around with an upcoming patch to remove user-modifiable > RULEs, I noticed that WHEN conditions were disallowed from INSTEAD OF > triggers for no discernible reason. This patch removes that > restriction. If you want to remove the restriction,