Date: Tue, 21 Sep 2021 03:23:48 -0500
From: Jaime Casanova <jcasanov@systemguards.com.ec>
To: Puneet Sharma <puneet.orcl@gmail.com>
Cc: "David G. Johnston" <david.g.johnston@gmail.com>,
	"pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17189: Index not created when primary key created
Message-ID: <20210921082348.GA12405@ahch-to>
References: <17189-521a1b29d9727929@postgresql.org>
 <CAKFQuwYf-rNmNenHsT3Vy=v-OMkDtin25yaxcSNwAbxmRki+tA@mail.gmail.com>
 <CALETbT9ZZPyLAc4+OU=hD5xP0c3iywFq0n-DqoOYwjVEOq8aGg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CALETbT9ZZPyLAc4+OU=hD5xP0c3iywFq0n-DqoOYwjVEOq8aGg@mail.gmail.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
Archived-At: 
 <https://www.postgresql.org/message-id/20210921082348.GA12405%40ahch-to>
Precedence: bulk

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