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
