Re: BUG #17189: Index not created when primary key created

On Tue, Sep 21, 2021 at 11:34:37AM +0530, Puneet Sharma wrote:
> Hi David,
>
> Is it different from postgres 12 version and postgres 12.8 version.
>
> When we are creating composite primary key default constraint has been
> created but not index like oracle.
>

no, it's not different.

"""
postgres=# select version();
version
----------------------------------------------------------------------------------------
PostgreSQL 12.0 on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
(1 row)

postgres=# create table t1(a int, b int, c int, primary key (a,b,c));
CREATE TABLE
postgres=# select indexrelid::regclass::text from pg_index
postgres-# where indrelid = 't1'::regclass and indisprimary;
indexrelid
------------
t1_pkey
(1 row)
"""

this has worked the right way for a long time, I would even say more
than 20 years. It's not suddenly failing.

As Hubert asked, please provide the output of `\d table_name`, or maybe
execute this query:

"""
select indexrelid::regclass::text from pg_index
where indrelid = 'table_name'::regclass
and indisprimary;
"""

--
Jaime Casanova
Director de Servicios Profesionales
SystemGuards - Consultores de PostgreSQL