On Mon, Oct 26, 2009 at 4:30 PM, Josh Berkus <j...@agliodbs.com> 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 (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers