Flyway Clean on PostgreSQL leaves TYPES

[ghost]

Original author: p.malo...@gmail.com (May 30, 2013 21:29:27)

Using PostgreSQL 9.2.
I have a migration of the form:

CREATE TYPE my_type AS (my_type_id integer);

When I execute a "clean" command, it remains in the database. Looking at Flyway's source code, TYPES to clean are listed using the following SQL:
select typname from pg_catalog.pg_type where typcategory in ('P', 'U') and typnamespace in (select oid from pg_catalog.pg_namespace where nspname = ?)

I looked up the TYPE "my_type" in this table and it is of typcategory 'C'.

At this point, I'm not sure if I should be creating my TYPE differently so that it registers as a 'P' or 'U' TYPE (but how?)... or if the SQL query is too restrictive.
Any insight would be helpful.

Thanks in advance.
Patrick Malouin

Original issue: http://code.google.com/p/flyway/issues/detail?id=506