Hi, I came across an anomaly yesterday which I would like clarified. I am using 6.5.3 but I don't know whether this is version specific. I created a new db user with a name that was 14 characters long, I allowed createuser to also create a dbase of the dame name. So far so good. There is no corresponding unix user so everything seemed fine. I then tried to add this user to an existing pg_passwd file. I didn't get an error, but it didn't add it either. What pg_passwd did do was to truncate the name to 8 characters, it then found an existing user as the root of my long name is an existing unix/postgres user and changed the password for that entry. This isn't what I wanted to happen. After some experimentation I found that I could add a user xxx to the file with pg_passwd and then edit the file and change the xxx to the correct 14 character name. Is there a defined max length for postgreSQL user names ? If there is and it is 8, then createuser should enforce it. If the length is > 8 then pg_passwd needs fixing so that it doesn't truncate. In either case, a message should have been given rather than the silent truncation, as it had me foxed for a while as to why my new user couldn't use the database and the existing user couldn't either. -- Glen and Rosanne Eustace, GodZone Internet Services, a division of AGRE Enterprises Ltd., P.O. Box 8020, Palmerston North, New Zealand Ph: +64 6 357 8168, Mobile: +64 21 424 015
