From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | CREATE TABLE oddity? |
Date: | 2002-10-31 13:54:56 |
Message-ID: | Pine.LNX.4.21.0210311346440.6898-100000@ponder.fairway2k.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Jochem van Dieten | 2002-10-31 13:59:58 | Re: CREATE TABLE oddity? |
Previous Message | Murali Mohan Kasetty | 2002-10-31 13:50:40 | Unable to get the connection through Java process |