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
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 |