Re: Problem in creating a table

Try this

CREATE TABLE test.TD_ACCESSCOUNT(
AC_YEAR NUMERIC(4,0) NOT NULL,
AC_MONTH NUMERIC(2,0) NOT NULL,
AC_DAYS NUMERIC(2,0) NOT NULL,
OFFICE_ID VARCHAR(7) NOT NULL,
AC_COUNT NUMERIC(6,0) DEFAULT 0,
PRIMARY KEY(AC_YEAR,AC_MONTH,AC_DAYS,OFFICE_ID)
)

2005/5/17, Wen Guangcheng <wen(at)microcourt(dot)co(dot)jp>:
>
> Hi Klint,
>
> Thanks for your help.
> But the error message still exists even though the 2 was droped from the
> varchar.
>
> --Wen
>
> ----- Original Message -----
> From: "Klint Gore" <kg(at)kgb(dot)une(dot)edu(dot)au>
> To: "Wen Guangcheng" <wen(at)microcourt(dot)co(dot)jp>
> Cc: <pgsql-general(at)postgresql(dot)org>
> Sent: Tuesday, May 17, 2005 4:17 PM
> Subject: Re: [GENERAL] Problem in creating a table
>
> > On Tue, 17 May 2005 15:47:55 +0900, "Wen Guangcheng" <
> wen(at)microcourt(dot)co(dot)jp> wrote:
> > > OFFICE_ID VARCHAR2(7) NOT NULL,
> >
> > This used to be oracle? drop the 2 from the varchar.
> >
> > klint.
> >
> > +---------------------------------------+-----------------+
> > : Klint Gore : "Non rhyming :
> > : EMail : kg(at)kgb(dot)une(dot)edu(dot)au : slang - the :
> > : Snail : A.B.R.I. : possibilities :
> > : Mail University of New England : are useless" :
> > : Armidale NSW 2351 Australia : L.J.J. :
> > : Fax : +61 2 6772 5376 : :
> > +---------------------------------------+-----------------+
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>