Wen Guangcheng wrote:
(B
(BHi,
(B
(B> TABLESPACE RAPIS;
(B> psql:/opt/rapisa/sql/TD_ACCESSCOUNT.sql:14: ERROR: syntax error at or near
(B> "(" at character 52
(B
(B> I really don't know what is wrong with it and do appreciate it if anyone would
(B> point out it. The version of Postgresql
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
Wen Guangcheng wrote:
(B> Hi Gurus,
(B
(BHi!
(B
(B> CREATE TABLE TD_ACCESSCOUNT(
(B> AC_YEAR NUMBER(4,0)NOT NULL,
(B> AC_MONTHNUMBER(2,0)NOT NULL,
(B> AC_DAYS NUMBER(2,0)NOT NULL,
(B> OFFICE_ID VARCHAR2(7)NOT NULL,
(B> AC_COUNTNUMBER(6
heng" <[EMAIL PROTECTED]>Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, May 17, 2005 4:17 PMSubject: Re: [GENERAL] Problem in creating a table> On Tue, 17 May 2005 15:47:55 +0900, "Wen Guangcheng" <[EMAIL PROTECTED]
> wrote:> > OFFICE_ID VARCHAR2(7
On Tue, 17 May 2005 16:33:33 +0900, "Wen Guangcheng" <[EMAIL PROTECTED]> 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
05 4:17 PM
Subject: Re: [GENERAL] Problem in creating a table
> On Tue, 17 May 2005 15:47:55 +0900, "Wen Guangcheng" <[EMAIL PROTECTED]>
> wrote:
> > OFFICE_ID VARCHAR2(7)NOT NULL,
>
>
Wen Guangcheng wrote:
(B> Hi Gurus,
(B>
(B> When I try to create a table by a script I get a error as follows,
(B> #
(B> [EMAIL PROTECTED] pgsql]$ psql -d postgres -e -f
(B> /opt/rapisa/sql/TD_ACCESSCOUNT.sql
(B>
(B> CREATE TABLE TD_ACC
On Tue, 17 May 2005 15:47:55 +0900, "Wen Guangcheng" <[EMAIL PROTECTED]> wrote:
> OFFICE_ID VARCHAR2(7)NOT NULL,
This used to be oracle? drop the 2 from the varchar.
klint.
+---+-+
: Klint Gore: "Non rhymi
