activewarehouse/adapter_extensions — pull request #2 by stellard (2012-06-14 13:53:33+00:00)
Title: Multiple truncate support for Postgres

This patch allows you to truncate multiple tables at once.

etl example

pre_process :truncate, :target => DATA_WAREHOUSE, :table => ['foo', 'bar']

This is necessary, at least in postgres because of foreign key constraints.

This results in

TRUNCATE TABLE foo,bar