Unable to make subset of a PostgreSQL db with ARRAY columns

18F / rdbms-subsetter

Generates a subset of a relational database that respects foreign key constraints

Creative Commons Zero v1.0 Universal

313 stars 30 forks source link

Unable to make subset of a PostgreSQL db with ARRAY columns #22

Closed fbertola closed 6 years ago

fbertola commented 9 years ago

When I try to make a subset of a PostgreSQL db with ARRAY columns, rdbms-subsetter fails with this error:

column <column> is of type <type>[] but expression is of type text[]

Is there a way to force casting to the right type?

fbertola commented 9 years ago

After further investigation, I found that the problem was with ARRAY[ENUM] columns. This is a known problem. The proposed PR fixes that (albeit being a little bit of a hack :sweat_smile:).

catherinedevlin commented 6 years ago

Got your fix merged! Thank you! It will be in the next release.