Re: Bug #574: can not create tables that start with "Clinic"

There is no NUMBER data type. I believe you want to use the NUMERIC data
type.

-Edwin Grubbs

On Wed, 6 Feb 2002 pgsql-bugs(at)postgresql(dot)org wrote:

> Ivan Handler (ivan(at)jaildoc(dot)com) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> can not create tables that start with "Clinic"
>
> Long Description
> First I logged in to my Linux server (latest RH) as root and did a su -l postgres. I created a database called chttest using createdb with no problems. I then went into psql using chttest and did a \i /var/tmp/CHTdbNew.ddl which is the script I created. It created all of the tables (28 of them) that do not start with the string, "Clinic" and rejected the 5 that do. The error message for all 5 was identical:
> -------------------------------------------
> ERROR: parser: parse error at or near "("
> -------------------------------------------
>
> the line number was always given as the end of the clause. I have included the script for you to inspect. I have been all through this and had another programmer look at it, and we can find no other reason than the name. It is a pretty weird bug or a very subtle script problem that I can not see. I have just started to use PostGreSQL, so it could be me. I have enclosed the complete script.
>
>
> CREATE TABLE "Clinic"
> (
> "clinicid" SERIAL,
> "name" VARCHAR(30) NOT NULL,
> "cllinicDate" DATE NOT NULL,
> "clinicTime" TIME NOT NULL,
> "serviceid" INTEGER NOT NULL,
> "slots" NUMBER(2),
> "clinictypeid" INTEGER NOT NULL,
> CONSTRAINT "PK_Clinic" PRIMARY KEY ("clinicid")
> );
>