DELETE FROM node;
ALTER SEQUENCE node_node_id_seq RESTART WITH 1;

-- Generated columns need to be dropped and generated again. This causes also path support views to be dropped
ALTER TABLE node DROP COLUMN path CASCADE;
ALTER TABLE node DROP COLUMN relative_path CASCADE;