maria-discuss team mailing list archive

[Justin Swanhart <greenlion@xxxxxxxxx>]

Partitioned tables don't support referential constraints.

Composite partitioning only supports tables partitioned by RANGE or LIST and sub partitions may only be HASH or KEY.

Sent from my iPhone

> On Mar 14, 2016, at 5:52 AM, Ghazi Btissam <btissam.ghazi@xxxxxxxxx> wrote:
> 
> Hi,
> 
> 1- Could a partitioned table contain, or be referenced by, foreign keys?
> 
> 2- As I saw in MariaDb documentation ,the subpartitions may use either HASH or KEY partitioning. Does the LIST subpartitioning  exists in MariaDb? Can we use : a composite partitionning : RANGE/LIST?
> 
> Thanks
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp