Jan Wieck JanWieck at Yahoo.com
Thu Apr 8 06:26:57 PDT 2010
On 4/6/2010 7:05 PM, Steve Singer wrote:
> On Mon, 5 Apr 2010, Jaime Casanova wrote:
> 
>> well my main preocupation is to avoid developers to execute truncate,
>> but maybe the answer is to revoke that privilege in 8.4
> 
> You could maybe also accomplish this by installing your own TRUNCATE trigger 
> that prevents the truncate with an error.
> 
> At some point some thought/discussion should be put into the best way of 
> adding truncate support to some future slony version.

It would require a special sl_log row so that the truncate is performed 
at the correct point within the sync. Just having T as the operation 
should do. Since it is a feature, I consider this a TODO for 2.1.


Jan

-- 
Anyone who trades liberty for security deserves neither
liberty nor security. -- Benjamin Franklin


More information about the Slony1-general mailing list