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