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

Re: Create table error

From: Ennio-Sr <nasr(dot)laili(at)tin(dot)it>
To: Kumar S <ps_postgres(at)yahoo(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Create table error
Date: 2004-09-14 21:19:40
Message-ID: 20040914211939.GA11168@deby.ei.hnet (view raw or flat)
Thread:
Lists: pgsql-novice
* Kumar S <ps_postgres(at)yahoo(dot)com> [140904, 13:38]:
> 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_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.

May be you should drop the underlined comma? 
Regards,	
	 Ennio.

-- 
[Perche' usare Win$ozz (dico io) se ..."anche uno sciocco sa farlo.     \\?//
 Fa' qualche cosa di cui non sei capace!"   (diceva Henry Miller) ]     (°|°)
[Why to use Win$ozz (I say) if ... "even a fool can do that.             )=(
 Do something you aren't good at!" (used to say Henry Miller) ]

In response to

pgsql-novice by date

Next:From: Kumar SDate: 2004-09-14 21:39:28
Subject: Re: Create table error
Previous:From: Stephan SzaboDate: 2004-09-14 20:43:09
Subject: Re: Create table error

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