CREATE GROUP oddity

Started by Jon Laphamover 25 years ago2 messages
#1Jon Lapham
jlapham@gandalf.bioqmed.ufrj.br

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
***-*--*----*-------*------------*--------------------*---------------

#2Peter Eisentraut
peter_e@gmx.net
In reply to: Jon Lapham (#1)
Re: 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