Bruce Momjian <[EMAIL PROTECTED]> writes: >> (Actually, what I'd prefer it do is try first for username, and >> then username@databasename if plain username isn't found.)
> Yes, that would be very easy to do _except_ for pg_hba.conf which does a > first-match for username. We could get into trouble there by trying two > versions of the same name. Comments? Hm. I think we'd have to switch around the order of stuff so that we look at the flat-file copy of pg_shadow first. Then we'd know which flavor of name we have, and we can proceed with the pg_hba match. The reason it's worth doing this is that 'postgres', for example, should be an installation-wide username even when you're using db-local names for ordinary users. > This may require raising the length of NAME type to be backwards > compatible. >> >> Right, but we're planning to do that anyway. > Yes, but that requires a protocol change, which we don't want to do for > 7.3. What? We've been discussing raising NAMEDATALEN for months, and no one's claimed that it qualifies as a protocol version change. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org