Re: pgcryto strangeness...

> > host=# SELECT DIGEST('asdf', 'md5') FROM users_shadow;
> > digest
> > ------------------------------------------------
> > \221.\310\003\262\316I\344\245A\006\215IZ\265p
> > (1 row)
>
> You must encode() the results.

Sorry for not being more clear, this isn't the problem: just proof
that things are working on this end.

> (For the record, I consider that a serious design flaw.
> It may not be possible to safely dump and restore tables
> containing unencoded 8-bit data.)

How about a digest_hex() method?

> > host=# SELECT DIGEST(password, 'md5') FROM users_shadow;
> > ERROR: Function 'digest(varchar, unknown)' does not exist
> > Unable to identify a function that satisfies the given argument types
> > You may need to add explicit typecasts
> > host=# SELECT DIGEST(CAST(password AS bytea), CAST('md5' AS TEXT)) FROM users_shadow;
> > ERROR: Cannot cast type 'varchar' to 'bytea'
>
> Try dropping the first cast.

Already have. I've cast it to text too. I've even tried having it
operate on char and text column types, it's looking for a bytea data
type, but I don't know how to cast to that correctly and that's the
problem (with the module?). Sorry I wasn't more explicitly earlier. -sc

host=# SELECT DIGEST(CAST(enabled AS bytea), CAST('md5' AS TEXT)) FROM users_shadow;
ERROR: Cannot cast type 'bpchar' to 'bytea'
host=# SELECT DIGEST(CAST(enabled AS text), CAST('md5' AS TEXT)) FROM users_shadow;
ERROR: Function 'digest(text, text)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
host=# SELECT DIGEST(CAST(password AS text), CAST('md5' AS TEXT)) FROM users_shadow;
ERROR: Function 'digest(text, text)' does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts

--
Sean Chittenden