Skip site navigation (1) Skip section navigation (2)

bug: 'alter table' in psql

From: bojay(at)malign(dot)penguinpowered(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: bug: 'alter table' in psql
Date: 1999-10-06 22:08:00
Message-ID: 19991006220800.16175.qmail@mail.malign.net (view raw or flat)
Thread:
Lists: pgsql-bugs
============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Signal 11
Your email address	:	signal11(at)mediaone(dot)net


System Configuration
---------------------
  Architecture (example: Intel Pentium)  	: K6/350

  Operating System (example: Linux 2.0.26 ELF) 	: Linux 2.2.9 i686

  PostgreSQL version (example: PostgreSQL-6.4.2)  :   6.4.2-3

  Compiler used (example:  gcc 2.8.0)		: gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)


Please enter a FULL description of your problem:
------------------------------------------------

alter table authentication add group char(64);
ERROR:  parser: parse error at or near "group"
^^ above command fails when passed to psql.


Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible: 
----------------------------------------------------------------------

- open psql and connect to any random database.
- type in 'alter table $YOUR_TABLE_NAME add group char(64);' and
  submit it to the backend. (the type doesn't matter)


If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------

pgsql's sql parser is probably assuming you want to use the keyword
'group' (ie: the "grant" command) instead of the name group to name
your field.

As an aside, I ran into this while trying to create some authentication
stuff for my website.  I can use "groups" instead without any problem..
but it's something you guys might want to look into - there might be
other bugs lurking in the parser that won't be so easy to find as this
one.

Ciao!


pgsql-bugs by date

Next:From: Marc-Oliver WesterburgDate: 1999-10-07 02:15:09
Subject: Minor problem in compiling Postgres 6.5.2
Previous:From: Justin LongDate: 1999-10-05 14:28:40
Subject: BUG: in SELECT DISTINCT

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group