questions about ON SELECT rules

Поиск
Список
Период
Сортировка
От Zhaomo Yang
Тема questions about ON SELECT rules
Дата
Msg-id CAOG7Ad1vpexaeM7MNZ4sr-3A8MXf5jrsi42AX1uXaDg65pxJJw@mail.gmail.com
обсуждение исходный текст
Список pgsql-hackers
Hi folks,

I'm working on a project where I need to run some commands/functions when SELECT are executed on certain tables. I looked at the rule system and found the following paragraph in the documentation:

  "Currently, there can be only one action in an ON SELECT rule, and it must be an unconditional SELECT action that is INSTEAD. This 
  restriction was required to make rules safe enough to open them for ordinary users, and it restricts ON SELECT rules to act like views."

These restrictions make it impossible  to implement what I need using the rule system. I'm think about tweaking how rule statement is executed to lift some restrictions (more actions, other type actions, etc.) but not sure what impacts this will introduce into the whole system. Why are rules not safe when these restrictions are removed?

Thanks,
Zhaomo 

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Alexander Korotkov
Дата:
Сообщение: Re: WIP: index support for regexp search
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: WIP: index support for regexp search