Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f92A4Pn18671 for ; Tue, 2 Oct 2001 06:04:25 -0400 (EDT) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id f929slZ99859 for pgsql-sql@postgresql.org; Tue, 2 Oct 2001 05:54:47 -0400 (EDT) (envelope-from news) From: "Rebekah Kirk" X-Newsgroups: comp.databases.postgresql.sql Subject: Stupid Question Date: Tue, 2 Oct 2001 10:55:35 +0100 Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 17 Message-ID: <9pc2t6$31ga$1@news.tht.net> X-Complaints-To: scrappy@hub.org X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4807.1700 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700 To: pgsql-sql@postgresql.org X-Archive-Number: 200110/10 X-Sequence-Number: 4965 I want to create a table and for whatever reason it will not accept the command, can anyone say what is wrong as I am very new to Postgres, thanks: CREATE TABLE cmpnycontacts ( ContactNo integer(10) NOT NULL SERIAL, CmpnyNo varchar(6) NOT NULL, FirstName varchar(30) NOT NULL, Surname varchar(30) NOT NULL, Phone varchar(20) NOT NULL, Mobile varchar(20) NOT NULL, Email varchar(40) NOT NULL, Country char(2) NOT NULL, CONSTRAINT cmpnycontacts_pkey PRIMARY KEY (ContactNo) );