Re: Rules and Command Status - update/insert/delete rule with series of commands in action

On 5/30/24 11:32, johnlumby@hotmail.com wrote:

> Any thoughts?      Any rationales one way or the other?    Any interest 
> in perhaps providing a choice via a configuration parameter?

1) As to using rules, stop now before you invest the time to find out is 
a road you don't want to go down.

2) Use INSTEAD OF triggers:

https://www.postgresql.org/docs/current/sql-createtrigger.html



> 
> 
> Cheers, John Lumby
> 
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com