On 18 August 2010 17:06, Justin Graf <justin@xxxxxxxxxxxx> wrote: > On 8/18/2010 9:15 AM, Clemens Eisserer wrote: >> Hi, >> >> >>> they are generated automatically. >>> >> Thanks depesz! >> The reason why I asked was because pgAdmin doesn't display the >> automatically created indices, which confused me. >> >> Thanks, Clemens >> > PGAdmin caches all database layout locally, the tree view can get very > stale. So refresh the treeview with either F5 or right click an item in > the treeview click refresh to rebuild the list. > I don't think PgAdmin will display indexes created by primary keys, only if indisprimary is false. -- Thom Brown Registered Linux user: #516935 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance