On Mon, Oct 26, 2009 at 4:30 PM, Josh Berkus <[email protected]> wrote: > >> Why aren't you satisfied with hashtext('foo') ? > > Collisions, mostly.
Why even bother with a hash function when you can just have multiple table pull from a shared sequence? AFAICT, this solves the OP's problem with no downsides (I used the approach with excellent results in a ported cobol app which had pessimistic locking requirement). merlin -- Sent via pgsql-hackers mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
