Cannot create tabel named 'user'

Поиск
Список
Период
Сортировка
Искать
От
pgsql-bugs@postgresql.org
Тема
Cannot create tabel named 'user'
Дата
Msg-id
200008292317.e7TNHYO90143@hub.org
Список
Дерево обсуждения
Cannot create tabel named 'user' pgsql-bugs@postgresql.org
Re: Cannot create tabel named 'user' "Harry W. Waddell" <waddell@caravan.com>
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
В списке pgsql-bugs по дате отправления
От: Tom Lane
Дата:
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: table aliases with updates
FAQ