Re: Delete rule does not prevent truncate
| От | Rob Sargent |
|---|---|
| Тема | Re: Delete rule does not prevent truncate |
| Дата | |
| Msg-id | 55B181F0.8060401@gmail.com обсуждение исходный текст |
| Ответ на | Re: Delete rule does not prevent truncate (Karsten Hilbert <Karsten.Hilbert@gmx.net>) |
| Ответы |
Re: Delete rule does not prevent truncate
|
| Список | pgsql-general |
On 07/23/2015 04:15 PM, Karsten Hilbert wrote:
Not sure about Tim and the Blackhats (there's a band name in there somewhere) but Wouldn't OP have exact same code to fix, one way or another?On Thu, Jul 23, 2015 at 12:28:32PM -0600, Rob Sargent wrote:I'm suggesting OP might find changing truncate statements to deletes (without a where clause) a simpler solution. Something has to change.Well, OP isn't looking for a solution to "delete all rows" but rather to _prevent_ deletion. Tim can't go forth and tell Blackhats to "please use DELETE rather than TRUNCATE", right ? AFAICT it'd be more useful to advise OP to revoke TRUNCATE rights on tables. Karsten
В списке pgsql-general по дате отправления: