TRUNCATE - Mailing list pgsql-hackers

From Rod Taylor
Subject TRUNCATE
Date
Msg-id 02db01c1f9cd$1cd68fc0$0f02000a@jester
Whole thread Raw
Responses Re: TRUNCATE
List pgsql-hackers
For my own protection I'm adding checks to truncate so that if there
is an ON DELETE trigger it will not execute the truncate command.

Anyway, should it really only be 'Disallow TRUNCATE on tables that are
involved in referential constraints'?

I'm thinking it should check for an on delete rule as well as user
triggers.


--
Rod



pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Making the regression tests locale-proof
Next
From: Ian Barwick
Date:
Subject: Re: Set Returning Functions (SRF) - request for patch review