On Thu, 1 Aug 2002, Bruce Momjian wrote: > Peter Eisentraut wrote: > > Bruce Momjian writes: > > > > > OK, I have attached a patch for testing. Sample output is: > > > > > > $ sql -U guest test > > > psql: FATAL: user "test.guest" does not exist > > > $ createuser test.guest > > > > I will object to any scheme that makes any characters in the user name > > magic. Two reasons: First, do it right, make a separate column. > > Second, several tools use URI syntax to specify data sources. This will > > break any feature that relies on being able to put special characters into > > the user name. > > > > The right solution to having database-local user names is putting extra > > information into pg_shadow regarding which database this user applies to. > > It could be an array or some separate "authentication domain" thing. > > OK, if you object, you can say goodbye to this feature for 7.3. I can > supply the patch to Marc and anyone else who wants it but I am not > inclined nor convinced we need that level of work for this feature. > > So we end up with nothing.
Stupid qustion .. but why can't you just add a 'domain' column to pg_passwd/pg_shadow so that its stored as two fields instead of one? Which I believe is what Pter is/was suggesting ... ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
