Currently TRUNCATE statement with RESTART IDENTITY clause doesn't work, since there is no way to restart a sequence at the GTM. This feature requests to add the support for TRUNCATE with RESTART IDENTITY.
The feature has been disabled by commit commit d337476e7c0a49f2b8d05a8c5a1c9be65683bb41
Author: Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Date: Wed May 8 11:41:45 2013 +0530
TRUNCATE statement with RESTART IDENTITY clause is not supported in this
release. Error out when TRUNCATE with RESTART IDENTITY is specified. Alternate
expected output is updated with error message and consequences of the same.
Original patch by Nikhil Sontakke.