On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar <[email protected]> wrote: > Tom, > The query which you gave returns me 0 rows. > select ctid,xmin,xmax,* from pg_index where indexrelid in > (select indexrelid from pg_index group by 1 having count(*)>1); > Regards, > Bhakti
How about just select ctid,xmin,xmax,* from pg_index? -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-performance mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
