Re: Problem in creating a table

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
Subject: Re: Problem in creating a table
Date: 2005-05-17 07:46:45
Message-ID: 4289A165166.B440KG@129.180.47.120
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 17 May 2005 16:33:33 +0900, "Wen Guangcheng" <wen(at)microcourt(dot)co(dot)jp> wrote:
> Hi Klint,
>
> Thanks for your help.
> But the error message still exists even though the 2 was droped from the varchar.

try taking the double quotes out of the primary key (as richard said)
and change number to numeric

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dan Black 2005-05-17 07:47:26 Re: Problem in creating a table
Previous Message Wen Guangcheng 2005-05-17 07:33:33 Re: Problem in creating a table