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
