Re: Create table error - Mailing list pgsql-novice

From Ennio-Sr
Subject Re: Create table error
Date
Msg-id 20040914211939.GA11168@deby.ei.hnet
Whole thread Raw
In response to Create table error  (Kumar S <ps_postgres@yahoo.com>)
List pgsql-novice
* Kumar S <ps_postgres@yahoo.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) ]

pgsql-novice by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Create table error
Next
From: Kumar S
Date:
Subject: Re: Create table error