Error in creating Primary Key

From: Mark Hortman <mark(at)swapstuff(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Error in creating Primary Key
Date: 2000-01-30 16:25:56
Message-ID: 38946614.38E60DF8@swapstuff.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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....

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Vazsonyi 2000-01-31 14:13:55 Re: [ADMIN] Attribute 'aggtransfn1' is repeated
Previous Message Laurent CASTELLANI 2000-01-30 15:22:59 Info