migra icon indicating copy to clipboard operation
migra copied to clipboard

Migra does not detect/support composite types

Open autumnjolitz opened this issue 6 years ago • 4 comments

Example:

Initialize a database with this type:

CREATE TYPE test_type AS (foo TEXT, bar TEXT);

Compare to a database without that type.

Expectation: Migra detects the missing type and runs a CREATE TYPE ... AS

What actually happens: It sees no difference between databases.

I've resorted to pre-creating the composite types in question before running a comparison.

autumnjolitz avatar Aug 28 '19 01:08 autumnjolitz

Thanks for filing this, I appreciate it!

I have an implementation in progress to fix this. Given my current schedule, it may take a bunch more time, however!

djrobstep avatar Sep 28 '19 23:09 djrobstep

@djrobstep I am also interested in support for composite types in migra. Is your in-progress work something that I could use as a starting point to implement this myself? If so, would you mind pushing that branch to Github? (or did I perchance miss it?)

emmanuel avatar Feb 04 '20 19:02 emmanuel

Curious as to what the plan is here?

kchaliki avatar Apr 26 '21 11:04 kchaliki

The support table at https://databaseci.com/docs/migra says "custom types/domains - Basic support (drop-and-create only, no alter)" but I'm also not seeing types in the generated migrations.

bard avatar May 05 '21 14:05 bard