From: | "Wen Guangcheng" <wen(at)microcourt(dot)co(dot)jp> |
---|---|
To: | "Dan Black" <fireworker(at)gmail(dot)com> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Problem in creating a table(Thanks) |
Date: | 2005-05-17 08:39:55 |
Message-ID: | 005801c55abc$03fcd560$2908a8c0@office.jsys.fukuokau.ac.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
Yes.it works.
Thanks a lots to all of you.
Cheers,
--Wen
----- Original Message -----
From: Dan Black
To: Wen Guangcheng
Cc: pgsql-general(at)postgresql(dot)org
Sent: Tuesday, May 17, 2005 4:47 PM
Subject: Re: [GENERAL] 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
From | Date | Subject | |
---|---|---|---|
Next Message | Margus Roo | 2005-05-17 09:27:28 | psql -U user -l cive all db list |
Previous Message | Robin Ericsson | 2005-05-17 07:56:21 | Re: Problem in creating a table |