Re: Duplicate Index Creation

On Tue, Jul 3, 2012 at 9:25 AM, Samuel Stearns <SStearns(at)internode(dot)com(dot)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