[GENERAL] Problem in creating a table

2005-05-16 Thread Wen Guangcheng
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)

Re: [GENERAL] Problem in creating a table

2005-05-17 Thread Wen Guangcheng
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" <[EMAIL PROTECTED]> To: "Wen Guangcheng" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 17, 20

Re: [GENERAL] Problem in creating a table(Thanks)

2005-05-17 Thread Wen Guangcheng
Hello, Yes.it works. Thanks a lots to all of you. Cheers, --Wen - Original Message - From: Dan Black To: Wen Guangcheng Cc: pgsql-general@postgresql.org Sent: Tuesday, May 17, 2005 4:47 PM Subject: Re: [GENERAL] Problem in creating a table Try this CREATE TABLE