Cannot create tabel named 'user'

Поиск
Список
Период
Сортировка
От pgsql-bugs@postgresql.org
Тема Cannot create tabel named 'user'
Дата
Msg-id 200008292317.e7TNHYO90143@hub.org
обсуждение исходный текст
Ответы Re: Cannot create tabel named 'user'  ("Harry W. Waddell" <waddell@caravan.com>)
Список 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,
becauseI 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
Дата:
Сообщение: Re: Re: [GENERAL] cannot vacuum a database !
Следующее
От: pgsql-bugs@postgresql.org
Дата:
Сообщение: table aliases with updates