Обсуждение: 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
************
On Thu, 7 Oct 1999, Peter Mount wrote:
> I think its because the parser forces everything outside of quotes to
> being lowercase.
>
Yes, it is right, but in tutorial is nothing about it, In tutorial is
this bad example:
CREATE USER davide WITH PASSWORD jw8s0F4
Password is very important....
Zakkr
> > > On Thu, 7 Oct 1999, Peter Mount wrote: > > > I think its because the parser forces everything outside of quotes to > > being lowercase. > > > > Yes, it is right, but in tutorial is nothing about it, In tutorial is > this bad example: > > CREATE USER davide WITH PASSWORD jw8s0F4 > > Password is very important.... > > Zakkr Fixed documentation. Thanks. -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026