Home > mailing lists

create/alter user extension syntax - Mailing list pgsql-hackers

From	Peter Eisentraut
Subject	create/alter user extension syntax
Date	November 19, 1999 23:33:38
Msg-id	Pine.LNX.4.20.9911190103100.714-100000@localhost.localdomain Whole thread Raw
List	pgsql-hackers

Tree view

I tried the following:

{CREATE|ALTER} USER username
[ WITH ID/UID/<whatever> number ]
[ WITH PASSWORD password ]
[ etc. as usual ]

which gives shift/reduce conflicts, even if I make PASSWORD and
ID/whatever a pure keyword (WITH is already one). So that won't work.

I am currently basing my "experiments" on CREATE USER name [ SYSID nr ] [
WITH PASSWORD ... ] ... which allows SYSID to be a ColId. Any better (and
working) syntax suggestions are welcome.

(Also, the idea would be to reuse "SYSID" for a CREATE GROUP (any day now
;) statement, so no UID.)

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

pgsql-hackers by date:

From: wieck@debis.com (Jan Wieck)
Date: 19 November 1999, 22:22:37
Subject: Re: [HACKERS] 7.0 status request

From: Thomas Lockhart
Date: 20 November 1999, 01:08:39
Subject: Re: [HACKERS] create/alter user extension syntax

create/alter user extension syntax - Mailing list pgsql-hackers

Previous

Next