Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrian Klaver
Subject Re: Rules and Command Status - update/insert/delete rule with series of commands in action
Date
Msg-id d9633950-7f00-49c2-9f74-3b2b1ae0fce0@aklaver.com
Whole thread Raw
In response to Rules and Command Status - update/insert/delete rule with series of commands in action  ("johnlumby@hotmail.com" <johnlumby@hotmail.com>)
Responses Re: Rules and Command Status - update/insert/delete rule with series of commands in action
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Rules and Command Status - update/insert/delete rule with series of commands in action
Next
From: "Wong, Kam Fook (TR Technology)"
Date:
Subject: How to delete column level Stats/Histogram