CREATE TABLE oddity?

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

Responses

Browse pgsql-general by date

  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