Skip site navigation (1) Skip section navigation (2)

Create table error

From: Kumar S <ps_postgres(at)yahoo(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Create table error
Date: 2004-09-14 20:38:35
Message-ID: 20040914203835.68225.qmail@web61208.mail.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-novice
Dear group, 
Could you please suggest if my sql syntax is wrong for
creating the table:
my sql statements:
create table EXPERIMENT
(
        exp_id          serial,
        exp_name        varchar(32)     not null,
        con_id          serial  references
contacts(con_id),
        exp_type        varchar(32)     not null,
        exp_desc        varchar(64),
        exp_pmid        integer(30)     not null,
        exp_rawdata_url varchar(32),
        constraint      experiment_pk primary
key(exp_id)
);


When I compile this I get the following error:
psql:/home/sk/temp/postgres/exp.sql:11: ERROR:  syntax
error at or near "(" at character 200

What is wrong with my code.

Please help. 

SK

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Responses

pgsql-novice by date

Next:From: Stephan SzaboDate: 2004-09-14 20:43:09
Subject: Re: Create table error
Previous:From: Betsy BarkerDate: 2004-09-14 16:24:37
Subject: Re: LockAcquire: lock table 1 is out of memory

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group