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 PS: > If you look at the documentation page for CREATE TABLE, you'll see > the following ..... but if you use your > browser to search for PRIMARY KEY within the page, it's not too hard > to find. Its quite harsh to imply I didn't look for documentation. I looked at the "Indexes and ORDER BY" which doesn't mention it, or I've overlook it. Doesn't make a difference anyway. > Also, if you create a primary key or a unique constraint on a table, > you should see a notice informing you of the creation of the index, > and its name. I use Hibernate, and it generates the DDL for me. Even with debug/DDL/SQL-output enabled, I don't get any hint that an index was created. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
