On Mon, Feb 28, 2011 at 12:08 AM, Bhakti Ghatkar <bghatkar@zedo.com> 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