Re: Duplicate Index Creation

On Tue, Jul 3, 2012 at 10:19 AM, Raghavendra <
raghavendra(dot)rao(at)enterprisedb(dot)com> wrote:

>
> 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
>
>
Opps... correction in my query WHERE clause, it should be pointing to
relname not index -- >where relname=' input_transaction_snbs' <--

--Raghav