Re: Problem in creating a table

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 : :
> +---------------------------------------+-----------------+
>