Stefan Keller <sfkeller@xxxxxxxxx> writes: > My explanation is that the message (saying that an index was > implicitly created) is simply wrong. The correct explanation is that you're misinterpreting whatever output you're looking at. Every unique or pkey constraint has an underlying index --- the index is the implementation mechanism for the constraint, so this is assuredly so. Some tools that show both constraints and indexes will omit constraint-associated indexes from the listing, since otherwise they'd be showing duplicate information. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
