Hello-

	I found the following odd behavior in v7.0.2 when issuing the
'create group' command.  Namely, I cannot create a group named 'trusted'
unless I use 'insert into pg_group...' syntax.  Any other group name works
as expected... well, at least those that I have tried.

	Cheers, Jon

	PS: I am running home-rolled v7.0.2 of Pg, on a linux v2.2.16 i686
box.  I have also test this on a v7.0.1 installation, with the same
result.  I cannot test this on a v6.5.x installation, b/c the 'create
group' command did not exist then.

------------------------------------------------------------------
template1=# create group trusted;
ERROR:  parser: parse error at or near "trusted"
template1=# insert into pg_group (groname) values ('trusted');
INSERT 18786 1


-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
 Jon Lapham
 Centro Nacional de Ressonancia Magnetica Nuclear de Macromoleculas
 Universidade Federal do Rio de Janeiro (UFRJ) - Brasil
 email: jlapham@gandalf.bioqmed.ufrj.br  
***-*--*----*-------*------------*--------------------*---------------

Mon, 19 Jun 2000 14:04:38 -0300 (BRT)
Jon Lapham <jlapham@gandalf.bioqmed.ufrj.br>
CREATE GROUP oddity
Jon Lapham writes:

> Hello-
> 
> 	I found the following odd behavior in v7.0.2 when issuing the
> 'create group' command.  Namely, I cannot create a group named 'trusted'
> unless I use 'insert into pg_group...' syntax.  Any other group name works
> as expected... well, at least those that I have tried.

TRUSTED is a reserved word. Try CREATE GROUP "trusted" (double quoted).

-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Tue, 20 Jun 2000 18:43:19 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
Re: CREATE GROUP oddity