CREATE TABLE oddity?

Поиск
Список
Период
Сортировка
От Nigel J. Andrews
Тема CREATE TABLE oddity?
Дата
Msg-id Pine.LNX.4.21.0210311346440.6898-100000@ponder.fairway2k.co.uk
обсуждение исходный текст
Ответы Re: CREATE TABLE oddity?
Список pgsql-general

I must be missing something but I don't know what and I can't see anything in
the create table documentation (from 7.2.1) mentioning this.

When I do, in psql:

-- in this I have tried atype as int, serial and varchar
CREATE TABLE user (
something atype
);

I get the following response:

ERROR:  parser: parse error at or near "user"

It is down to the table name I'm trying to use but I don't see why it's
disallowed. Is user a special reserved word in the parser?

                            version
---------------------------------------------------------------
 PostgreSQL 7.2.3 on i686-pc-linux-gnu, compiled by GCC 2.95.2
(1 row)


psql version is the 7.2.3 install and is dynamically linked with:

        libpq.so.2 => /usr/local/stow/pgsql-7.2.3/lib/libpq.so.2 (0x40014000)
        libpam.so.0 => /lib/libpam.so.0 (0x4002f000)
        libz.so.1 => /usr/lib/libz.so.1 (0x40037000)
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x40047000)
        libresolv.so.2 => /lib/libresolv.so.2 (0x40074000)
        libnsl.so.1 => /lib/libnsl.so.1 (0x40083000)
        libdl.so.2 => /lib/libdl.so.2 (0x40099000)
        libm.so.6 => /lib/libm.so.6 (0x4009d000)
        libreadline.so.4 => /lib/libreadline.so.4 (0x400ba000)
        libc.so.6 => /lib/libc.so.6 (0x400df000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
        libncurses.so.5 => /lib/libncurses.so.5 (0x401bd000)


Unfortunately I don't have time to investigate the source to see why I am not
allowed a table called user.

BTW, user attempting the create table is not the/a superuser and owns the
database.


--
Nigel J. Andrews


В списке pgsql-general по дате отправления:

Предыдущее
От: Murali Mohan Kasetty
Дата:
Сообщение: Unable to get the connection through Java process
Следующее
От: Jochem van Dieten
Дата:
Сообщение: Re: CREATE TABLE oddity?