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

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Re: Rules and Command Status - update/insert/delete rule with series of commands in action
Дата
Msg-id d9633950-7f00-49c2-9f74-3b2b1ae0fce0@aklaver.com
обсуждение исходный текст
Ответ на Rules and Command Status - update/insert/delete rule with series of commands in action  ("johnlumby@hotmail.com" <johnlumby@hotmail.com>)
Ответы Re: Rules and Command Status - update/insert/delete rule with series of commands in action
Список pgsql-general
Дерево обсуждения 
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Rules and Command Status - update/insert/delete rule with series of commands in action
Следующее
От: "Wong, Kam Fook (TR Technology)"
Дата:
Сообщение: How to delete column level Stats/Histogram