← Back to team overview

maria-discuss team mailing list archive

Re: Partitionning question

 

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


References