Hi Gurus,
When I try to create a table by a script I get a error as follows,
#####################################################
[EMAIL PROTECTED] 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
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match