On 11/15/2012 06:25 PM, Hannu Krosing wrote: > On 11/15/2012 09:48 AM, Craig Ringer wrote: >> If you want to prevent TRUNCATE, deny the privilege or add a trigger >> that aborts the command. > You can abort the transaction but not skip action as currently it is only > possible to skip in ROW level triggers. > > So I'd modify this request to allow BEFORE EACH STATEMENT triggers > to also be able to silently skip current action like BEFORE EACH ROW > triggers can. > > Then this request would simply be satisfied by a simple trigger which > rewrites TRUNCATE into DELETE . That seems sensible to me, too.
-- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
