Re: Problem in creating a table

From: Robin Ericsson <robin(dot)ericsson(at)profecta(dot)se>
To: Wen Guangcheng <wen(at)microcourt(dot)co(dot)jp>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem in creating a table
Date: 2005-05-17 07:56:21
Message-ID: 4289A3A5.1010703@profecta.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Wen Guangcheng wrote:
> Hi Gurus,

Hi!

> CREATE TABLE TD_ACCESSCOUNT(
> AC_YEAR NUMBER(4,0) NOT NULL,
> AC_MONTH NUMBER(2,0) NOT NULL,
> AC_DAYS NUMBER(2,0) NOT NULL,
> OFFICE_ID VARCHAR2(7) NOT NULL,
> AC_COUNT NUMBER(6,0) DEFAULT 0,
> PRIMARY KEY("AC_YEAR","AC_MONTH","AC_DAYS","OFFICE_ID")
> )
> TABLESPACE RAPIS;
^^^^^^^^^^

> psql:/opt/rapisa/sql/TD_ACCESSCOUNT.sql:14: ERROR: syntax error at or near "(" at character 52
> #####################################################
>
> I really don't know what is wrong with it and do appreciate it if anyone would
> point out it. The version of Postgresql is 7.4.7.
> Thanks in advance.

Tablespace wasn't supported until 8.0

regards,
Robin

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Wen Guangcheng 2005-05-17 08:39:55 Re: Problem in creating a table(Thanks)
Previous Message Robin Ericsson 2005-05-17 07:52:46 Re: Problem in creating a table