RE: [HACKERS] password in pg_shadow

I think its because the parser forces everything outside of quotes to
being lowercase.

Peter

-- 
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.



-----Original Message-----
From: Zakkr [mailto:zakkr@zf.jcu.cz]
Sent: 07 October 1999 10:55
To: pgsql-hackers
Subject: [HACKERS] password in pg_shadow




Is all in next example good? See:

abil=> CREATE USER myname WITH PASSWORD BuBuBuBu;
CREATE USER                            ^^^^^^^^^^ 

abil=> select * from pg_shadow;
usename |usesysid|usecreatedb|usetrace|usesuper|usecatupd|passwd
|valuntil
myname  |    5808|f          |f       |f       |f        |bubububu   |
      ^^^^^^^^ 
 
(4 rows)


Why is in pg_shadow.passwd low case only?
                        Zakkr


************