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
