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

Potential bug

From: James Vinett <james(at)imdstrading(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Potential bug
Date: 2002-04-18 03:43:12
Message-ID: 1019101392.875.54.camel@james.imdstrading.com (view raw or flat)
Thread:
Lists: pgsql-bugs
To whom it may concern:

I tried to create a new table with the following statement:

	CREATE TABLE
		"bit" (
		provider_name varchar
		);



I got the error message:

ERROR:  TypeCreate: type bit already defined



According to your documentation 'PosetgreSQL 7.1 User's Guide' on page 2
it states:

A delimited identifier (or qouted identifier) is always an identifier,
never a key word. So "select" could be used to refer to a column or
table named select, whereas an unquoted select would be taken as a key
word and would therefore provoke a paser error when used where a table
or column name is expected. 

It then goes further to state in 'PostgreSQL 7.1 Reference Manual' on
page 54 the syntax for CREATE TABLE:


CREATE [ TEMPORARY | TEMP ] TABLE table (
    column type
[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
    [column_constraint_clause | PRIMARY KEY } [ ... ] ]
    [, ... ]
    [, PRIMARY KEY ( column [, ...] ) ]
    [, CHECK ( condition ) ]
    [, table_constraint_clause ]
    ) [ INHERITS ( inherited_table [, ...] ) ]


Is this exception that is being thrown correct?  If so you should state
that 'types' are excluded from the 'qouted identifier' rule.   Futher
more the exception makes it sound like I'm trying to CREATE TYPE, which
i am not.

james vinett
  






Responses

pgsql-bugs by date

Next:From: Bruce MomjianDate: 2002-04-18 04:32:17
Subject: Re: [PATCHES] A bug in gist code with fetch/move
Previous:From: Tom LaneDate: 2002-04-18 03:41:29
Subject: Re: FATAL 2: XLogWrite: write request 3/39000000 is past end of log 3/38FC2000 (fwd)

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