Обсуждение: Error in creating Primary Key

Поиск
Список
Период
Сортировка

Error in creating Primary Key

От
Mark Hortman
Дата:
Right out of the manual I am using the command...
CREATE TABLE distributors (
     did      DECIMAL(03) PRIMARY KEY DEFAULT NEXTVAL('serial'),
     name     VARCHAR(40) NOT NULL CHECK (name <> '')
);

Whenever I try to use a primary key, I get a message
notice: Create table/primary key will create implicit index
'distributors_pkey' for table distributors
and Worse...

ERROR: Can't find a default operator class for type 1700.

Any help would be appreciated....