[Solved] Why does this hash partitioning setup fail?CREATE TABLE data (key INT, value TEXT) PARTITION BY HASH (key);CREATE TABLE data_p0 PARTITION OF data FOR VALUES WITH (MODULUS 2, REMAINDER 0); | PostgreSQL

PostgreSQL - Table Partitioning

Why does this hash partitioning setup fail?

CREATE TABLE data (key INT, value TEXT) PARTITION BY HASH (key);
CREATE TABLE data_p0 PARTITION OF data FOR VALUES WITH (MODULUS 2, REMAINDER 0);

AMODULUS must be greater than 2

BPartition tables cannot be named with suffixes

CMissing partition for remainder 1

DHash partitioning requires a UNIQUE constraint

Step-by-Step Solution

Solution:

Step 1: Check completeness of partitions
With modulus 2, partitions must cover remainder 0 and 1; only remainder 0 partition exists.
Step 2: Validate other options
MODULUS can be 2; naming is allowed; UNIQUE constraint not required.
Final Answer:
Missing partition for remainder 1 -> Option C
Quick Check:
All remainders must have partitions [OK]

Quick Trick: Create partitions for all remainders 0 to modulus-1 [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Why does this hash partitioning setup fail?