Cannot create tabel named 'user'

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Cannot create tabel named 'user'
Date: 2000-08-29 23:17:34
Message-ID: 200008292317.e7TNHYO90143@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Roman Solomatin (roman(dot)solomatin(at)tele2(dot)ee) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Cannot create tabel named 'user'

Long Description
Cannot create a table named user no matter if the database is old or freshly created. It may be version specific, because I have PostgreSQL 6.5.3 and system administrator doesn't update it to 7.x version.

Sample Code
In psql:
template1=> create database new_database;
CREATEDB
template1=> \c new_database
connecting to new database: new_database
new_database=> create table user ( id int2 not null );
ERROR: parser: parse error at or near "user"
new_database=> create table users (id int2 not null );
CREATE
new_database=>

No file was uploaded with this report

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Harry W. Waddell 2000-08-29 23:54:13 Re: Cannot create tabel named 'user'
Previous Message pgsql-bugs 2000-08-29 23:02:53 table aliases with updates