Re: Converting BYTEA from/to BIGINT - Mailing list pgsql-general

From Dimitri Fontaine
Subject Re: Converting BYTEA from/to BIGINT
Date
Msg-id 87iq41qnxd.fsf@hi-media-techno.com
Whole thread Raw
In response to Re: Converting BYTEA from/to BIGINT  (Vincenzo Romano <vincenzo.romano@notorand.it>)
Responses Re: Converting BYTEA from/to BIGINT  (Vincenzo Romano <vincenzo.romano@notorand.it>)
List pgsql-general
Vincenzo Romano <vincenzo.romano@notorand.it> writes:
> Now, why doing this?
> I am using a plain SEQUENCE to create a (kind of) "session ID". That
> is simple but predictable.
> The idea is to use this function in conjunction with encrypt (from
> pgcrypto) and the blowfish algorithm
> to make that sequence numbers somehow unpredictable.
> I'm pretty sure there are better (or at least easier) solutions out
> there, but there needs to be also some fun
> in here.

I think you'd be interested into the following:

 http://wiki.postgresql.org/wiki/Pseudo_encrypt

Regards,
--
dim

pgsql-general by date:

Previous
From: "Davor J."
Date:
Subject: Re: Inheritance and trigger/FK propagation
Next
From: Dimitri Fontaine
Date:
Subject: Re: Integral PG DB replication