BUG #18345: Specifying index parameters for a PRIMARY KEY column constraint is a syntax error

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: contact(at)mettekou(dot)com
Subject: BUG #18345: Specifying index parameters for a PRIMARY KEY column constraint is a syntax error
Date: 2024-02-15 11:58:18
Message-ID: 18345-26e2bb64e445f71f@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18345
Logged by: Dylan Meysmans
Email address: contact(at)mettekou(dot)com
PostgreSQL version: 16.2
Operating system: openSUSE Tumbleweed
Description:

PostgreSQL 16.2 does not accept index parameters, such as an INCLUDE (...)
parameter, for a PRIMARY KEY column constraint in a CREATE TABLE DDL
statement. See https://dbfiddle.uk/6S1zwHRL for a minimal reproduction.
According to the documentation at
https://www.postgresql.org/docs/current/sql-createtable.html, this should be
allowed.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David G. Johnston 2024-02-15 13:22:58 Re: BUG #18345: Specifying index parameters for a PRIMARY KEY column constraint is a syntax error
Previous Message PG Bug reporting form 2024-02-15 09:00:01 BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy