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 по дате отправления: