Sqitch create enum templates for pg engine

pg_deploy_create_enum.tmpl

-- Deploy [% project %]:[% change %] to [% engine %]
[% FOREACH item IN requires -%]
-- requires: [% item %]
[% END -%]
[% FOREACH item IN conflicts -%]
-- conflicts: [% item %]
[% END -%]

BEGIN;

SET SEARCH_PATH TO [% IF schema %][% schema %],[% END %]public;
CREATE TYPE [% IF name %][% name %][% ELSE %][% change %][% END %] AS ENUM (
  [% FOREACH val IN value -%]
    '[% val %]'[% loop.last ? '' : ',' %]
  [% END -%]
);

COMMIT;

pg_revert_create_enum.tmpl

-- Revert [% project %]:[% change %] from [% engine %]

BEGIN;

SET SEARCH_PATH TO [% IF schema %][% schema %],[% END %]public;
DROP TYPE [% IF name %][% name %][% ELSE %][% change %][% END %] CASCADE;

COMMIT;

pg_verify_create_enum.tmpl

-- Verify [% project %]:[% change %] on [% engine %]

BEGIN;

SELECT true
FROM pg_type t
JOIN pg_namespace n ON t.typnamespace = n.oid
WHERE typname = '[% IF name %][% name %][% ELSE %][% change %][% END %]'
[% IF schema %]AND n.nspname = '[% schema %]'[% END %];

ROLLBACK;