Re: Problem in creating a table - Mailing list 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