What is wrong with this query?

From: "Jackson, Kevin J(dot)" <KJJACKS(at)twa(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: What is wrong with this query?
Date: 2000-02-28 18:10:34
Message-ID: 9D546E233EDED21180EC0090273C5BAD01D65912@twakcax2.twa.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Here's the query:

CREATE TABLE project_request (submit_date date ,
projectid serial ,
contact varchar not null ,
department varchar not null ,
telephone varchar not null ,
email varchar not null ,
project_name varchar not null ,
projectgoal1 varchar not null ,
projectgoal2 varchar ,
projectgoal3 varchar ,
projectgoal4 varchar ,
projectgoal5 varchar ,
projectgoal6 varchar ,
projectgoal7 varchar ,
PRIMARY KEY (projectid),
INDEX (projectid, project_name, email),
UNIQUE (projectid, project_name));

Here's the error I message I get:

ERROR: parser: parse error at or near "("

Please respond by email, as I am currently unable to get the list here at
work. (Curse those corprate amerver sysadmins!)

TIA!

Kevin J. Jackson
Internet Support/Development Specialist
TWA
kjjacks(at)twa(dot)com
http://www.twa.com

Browse pgsql-general by date

  From Date Subject
Next Message Henrique Pantarotto 2000-02-28 18:20:06 RE: RES: [GENERAL] Stored procedures returning multiple values... ?
Previous Message Bruce Momjian 2000-02-28 17:25:05 Re: [GENERAL] psql 7.0.0 beta