Re: Open 7.3 items

Rod Taylor <rbt@zort.ca> writes:

> >         - The functionality that Marc is worried about (in effect,
> >           allowing multiple database users with the same name) is
> >           pretty obscure, and the implementation is even more so. I
> >           doubt whether there is *anyone* other than Marc actually
> >           using it (if that's not the case, please speak up).
> 
> I would use database specific users for a similar area -- shared
> hosting.

I agree that the functionality Marc is looking for is useful -- I'm
just saying that I would bet that *no one* is using the current
implementation of it in PostgreSQL (i.e. so I don't see the need to
keep backward compatibility, or the harm in removing the feature for
the next release until a better solution is designed & implemented).

> But, could live with a longer (128 byte) namedatalen to allow
> a unique user%domain.

That seems like a serviceable solution to me -- it seems quite easy to
implement this functionality outside the database proper (at least
until a proper solution is devised). Keep in mind that the current
FE/BE protocol limits database and user names to 64 characters.
That's another thing I'd like to fix in 7.4.

Cheers,

Neil

-- 
Neil Conway <neilconway@rogers.com>
PGP Key ID: DB3C29FC