Re: [HACKERS] Solution to the pg_user passwd problem !?? (c) - Mailing list pgsql-hackers

From Ronald Baljeu
Subject Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)
Date
Msg-id 199802201521.QAA04648@xs2.xs4all.nl
Whole thread Raw
In response to Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Solution to the pg_user passwd problem !?? (c)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> >
> > > ------- OTHER WISE ---- CAN WE STEAL IDEAS FROM OTHERS? --------
> > >
> > > I'm also running MySQL (trying to switch to PG, but waiting for ODBC
> > > to catch up), I like the mysql feature of inserting passords by:
> > >
> > >     insert into user (host,user,password)
> > >     values ("domain.com","dlorenso",password('psswrd');
> >
> > Hmmm... When I read this, another (related) idea pops into my head.
> > It's probably nothing, but:
> >
> > what about defining a new type 'passwd', with
> > an input (or output) routine which does the crypting?
>
> If they do a binary cursor, does the output function get called?

Oops, I haven't thought about that. I guess it doesn't :(
Ok, what about an input routine that does the crypting?

One down, one to go...

Cheers,
Ronald

pgsql-hackers by date:

Previous
From: Ronald Baljeu
Date:
Subject: Re: [HACKERS] Who is everyone?
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Running pgindent