Re: Delete rule does not prevent truncate

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Delete rule does not prevent truncate
Дата
Msg-id 20150724100919.GA1956@crankycanuck.ca
обсуждение исходный текст
Ответ на Re: Delete rule does not prevent truncate  (Tim Smith <randomdev4+postgres@gmail.com>)
Список pgsql-general
On Fri, Jul 24, 2015 at 10:24:55AM +0100, Tim Smith wrote:
>
> If that's how the developers feel about rules, i.e they can't be
> bothered to make any changes to the rules code any more, no matter how
> minor (e.g. this TRUNCATE issue)

Who is this "they"?  As I think I suggested in another mail, if you
think this is trivial and easy then I think you should propose the
patch to solve it.  I understand what you're saying; I think the
solution is self-evident (add a statement trigger that captures
TRUNCATE and DO INSTEAD NOTHING), so I just wouldn't be bothered to
fix this.  But I suspect things are the way they are partly because
nobody proposed or implemented a patch for this behaviour before.

The manual is also quite clear in what statements you can
write rules about; by implication, other statements are not covered,
so I'm not actually sure why you think the manual is misleading.

Best regards,

A
--
Andrew Sullivan
ajs@crankycanuck.ca


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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Delete rule does not prevent truncate
Следующее
От: Zdeněk Bělehrádek
Дата:
Сообщение: Re: Using the database to validate data