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

Re: Create table error

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
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 20:43:09
Message-ID: 20040914134148.E25844@megazone.bigpanda.com (view raw or flat)
Thread:
Lists: pgsql-novice
On Tue, 14 Sep 2004, Kumar S wrote:

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

The type INTEGER doesn't take additional information in parens.
What range of values were you trying to hold?

In response to

Responses

pgsql-novice by date

Next:From: Ennio-SrDate: 2004-09-14 21:19:40
Subject: Re: Create table error
Previous:From: Kumar SDate: 2004-09-14 20:38:35
Subject: Create table error

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