Skip site navigation (1) Skip section navigation (2)

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

From: Edwin Grubbs <egrubbs(at)rackspace(dot)com>
To: <ivan(at)jaildoc(dot)com>, <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Bug #574: can not create tables that start with "Clinic"
Date: 2002-02-07 00:20:55
Message-ID: Pine.LNX.4.33.0202061818130.30038-100000@zamboni.wc6.rackspace.com (view raw or flat)
Thread:
Lists: pgsql-bugs
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")
> );
>


In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2002-02-07 15:17:28
Subject: Bug #575: Build Problem with Postgresql 7.1.3 on Aix 4.3.3 with VisualAge 5.0 compiler resources:
Previous:From: Peter EisentrautDate: 2002-02-07 00:20:47
Subject: Re: Bug #574: can not create tables that start with "Clinic"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group