Postgres Pro
Downloads
Home   >   mailing lists

BUG #17189: Index not created when primary key created - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #17189: Index not created when primary key created
Date
Msg-id 17189-521a1b29d9727929@postgresql.org
Whole thread Raw
Responses Re: BUG #17189: Index not created when primary key created  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: BUG #17189: Index not created when primary key created  (hubert depesz lubaczewski <depesz@depesz.com>)
Re: BUG #17189: Index not created when primary key created  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
The following bug has been logged on the website:

Bug reference:      17189
Logged by:          Puneet Sharma
Email address:      puneet.orcl@gmail.com
PostgreSQL version: 12.0
Operating system:   Linux
Description:

I have created the composite primary key which is created successfully but i
am not getting the index against the primary key.

When i created a select query and includes the primary key column it is
going with full table scan. Even i am creating an index on the columns it is
also going with full table scan.

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522)
Next
From: PG Bug reporting form
Date:
Subject: BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm