Re: Duplicate Index Creation - Mailing list pgsql-admin

On Tue, Jul 3, 2012 at 9:25 AM, Samuel Stearns <SStearns@internode.com.au> wrote:

Results of \d (without all the column defs):

Indexes:
    "input_transaction_snbs_prod_pkey" PRIMARY KEY, btree (id)
    "i1" btree (trans_client)
Check constraints:
    "chk_charge" CHECK (charge_type IS NULL OR charge_type = 'Recurring'::text OR charge_type = 'Usage'::text OR charge_type = 'Fee'::text OR charge_type = 'Equipment'::text OR charge_type = 'One-t
ime'::text OR charge_type = 'Reversal'::text OR charge_type = 'Adjustment'::text)

Thanks. I was checking any INVALID indexes on the table. Its fine, can try below query. 

select schemaname,relid,indexrelid,relname,indexrelname from pg_stat_all_indexes where relname='i1';

Also, try to ANALYZE the database and retry the queries. Its just to confirm that query results are getting from updated catalogs.

--Raghav