Cannot create tabel named 'user'

PostgreSQL Bugs List <pgsql-bugs@postgresql.org>

From: pgsql-bugs@postgresql.org
To: pgsql-bugs@postgresql.org
Date: 2000-08-29T23:17:34Z
Lists: pgsql-bugs
Roman Solomatin (roman.solomatin@tele2.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