[Solved] You try to create a partition for a range partitioned table by date with this command:CREATE TABLE sales_2025 PARTITION OF sales FOR VALUES FROM ('2025-01-01') TO ('2024-12-31');What is the problem... | PostgreSQL

PostgreSQL - Table Partitioning

You try to create a partition for a range partitioned table by date with this command:

CREATE TABLE sales_2025 PARTITION OF sales FOR VALUES FROM ('2025-01-01') TO ('2024-12-31');

What is the problem with this statement?

AThe TO date is earlier than the FROM date, causing a range error

BPartition names cannot contain numbers

CYou must specify LIST partitioning, not RANGE

DThe sales table must be dropped before adding partitions

Step-by-Step Solution

Solution:

Step 1: Check the FROM and TO values in partition definition
The TO value '2024-12-31' is before the FROM value '2025-01-01', which is invalid for range partitions.
Step 2: Understand partition range rules
Range partitions require FROM value to be less than TO value to define a valid range.
Final Answer:
The TO date is earlier than the FROM date, causing a range error -> Option A
Quick Check:
FROM must be less than TO in range partitions [OK]

Quick Trick: FROM date must be before TO date in range partitions [OK]

Common Mistakes:

Master "Table Partitioning" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

You try to create a partition for a range partitioned table by date with this command: