-- Keep identity allocation for new projects while allowing owned projects to swap positions. ALTER TABLE projects ALTER COLUMN position SET GENERATED BY DEFAULT;