Thread

bug: 'alter table' in psql

bojay@malign.penguinpowered.com — 1999-10-06T22:08:00Z

============================================================================
                        POSTGRESQL BUG REPORT TEMPLATE
============================================================================


Your name		:	Signal 11
Your email address	:	signal11@mediaone.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!