create/alter user extension syntax

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: hackers(at)postgresql(dot)org
Subject: create/alter user extension syntax
Date: 1999-11-20 01:34:38
Message-ID: Pine.LNX.4.20.9911190103100.714-100000@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 1999-11-20 02:19:49 RE: [HACKERS] 7.0 status request
Previous Message Jan Wieck 1999-11-20 00:13:54 Re: [HACKERS] 7.0 status request