To specify that the index not allow duplicate values, include the UNIQUE keyword. If the column or columns that make up the index contains duplicate values when you execute the
CREATE INDEX statement with the
UNIQUE keyword, Pervasive PSQL returns Status Code 5 and does not create the index.