Ecto and CockroachDB/Postgres support for INTERLEAVE directive?

Phoenix Forum Questions / Help
,
1

I was wondering how one might be able to establish/utilize a table using the INTERLEAVE IN PARENT directive when creating a new table using ecto schemas:
https://www.cockroachlabs.com/docs/stable/interleave-in-parent.html

Is there any sort of support/escape hatch for this? How might I be able to model my schema using this with Ecto?

Thanks!

2

Hi @perezd if you need an escape hatch during migrations you can use https://hexdocs.pm/ecto_sql/Ecto.Migration.html#execute/1

After the migration is done, it looks to me like ecto’s support for composite primary keys should sort out the rest that you need.

3

Awesome, thank you for the pointers!