On Tue, Jul 3, 2012 at 10:19 AM, Raghavendra < raghavendra....@enterprisedb.com> wrote:
> > On Tue, Jul 3, 2012 at 9:25 AM, Samuel Stearns > <sstea...@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 > > Opps... correction in my query WHERE clause, it should be pointing to relname not index -- >where relname=' input_transaction_snbs' <-- --Raghav
