[Solved] You try to create a list partitioned table with this command:CREATE TABLE items (id INT, category TEXT) PARTITION BY LIST category;What is the error in this statement? | PostgreSQL

PostgreSQL - Table Partitioning

You try to create a list partitioned table with this command:

CREATE TABLE items (id INT, category TEXT) PARTITION BY LIST category;

What is the error in this statement?

AThe table must have a primary key before partitioning.

BMissing parentheses around the partition column in PARTITION BY LIST.

CLIST partitioning does not support TEXT columns.

DPARTITION BY LIST must be written as PARTITION BY RANGE.

Step-by-Step Solution

Solution:

Step 1: Check syntax for PARTITION BY LIST
PostgreSQL requires parentheses around the column name in PARTITION BY LIST.
Step 2: Identify error in statement
The statement misses parentheses: should be PARTITION BY LIST (category).
Final Answer:
Missing parentheses around the partition column in PARTITION BY LIST. -> Option B
Quick Check:
PARTITION BY LIST syntax needs parentheses [OK]

Quick Trick: Always use parentheses around columns in PARTITION BY LIST [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You try to create a list partitioned table with this command: