Problem in creating a table

Поиск
Список
Период
Сортировка
От Wen Guangcheng
Тема Problem in creating a table
Дата
Msg-id 001c01c55aac$5eafa010$2908a8c0@office.jsys.fukuokau.ac.jp
обсуждение исходный текст
Ответы Re: Problem in creating a table  (Klint Gore <kg@kgb.une.edu.au>)
Re: Problem in creating a table  (Richard Huxton <dev@archonet.com>)
Re: Problem in creating a table  (Robin Ericsson <robin.ericsson@profecta.se>)
Re: Problem in creating a table  (Robin Ericsson <lobbin@localhost.nu>)
Список pgsql-general
Hi Gurus,

When I try to create a table by a script I get a error as follows,
#####################################################
[postgres@demo pgsql]$ psql -d postgres -e -f /opt/rapisa/sql/TD_ACCESSCOUNT.sql

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.

--Wen



В списке pgsql-general по дате отправления:

Предыдущее
От: MLikharev@micropat.com
Дата:
Сообщение: CREATE TEMP TABLE AS SELECT/ GET DIAGNOSTICS ROW_COUNT
Следующее
От: Klint Gore
Дата:
Сообщение: Re: Problem in creating a table