Re: Open 7.3 items - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: Open 7.3 items
Date
Msg-id Pine.LNX.4.44.0208011907480.6899-100000@localhost.localdomain
Whole thread Raw
In response to Re: Open 7.3 items  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Open 7.3 items
List pgsql-hackers
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.

-- 
Peter Eisentraut   peter_e@gmx.net



pgsql-hackers by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Module Portability
Next
From: Peter Eisentraut
Date:
Subject: Re: Trim the Fat (Was: Re: Open 7.3 items )