| From: | April L <april(at)i-netco(dot)com> |
|---|---|
| To: | PgSQL Novice ML <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Is a randomized default value primary key possible? |
| Date: | 2002-05-19 16:10:04 |
| Message-ID: | 3.0.5.32.20020519121004.06db8ec8@mail.i-netco.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
After reading about data types, create table, and other search results for
"default" and "random" in the postgres idocs, I haven't found a way to do
this:
Instead of a sequentially auto-incrementing primary key, I would like a
random 16 byte character value (assumedly hex) to be automatically created
as the default value for each new record.
I guess I could just use a large random number, created with the postgres
random() function - however I don't see any way of seeding it, or know if
that is necessary.
The purpose of using a random rather than sequential number is to prevent
people being able to access other's records by guessing.
Has anyone else encountered this challenge, and do you know of a way to
generate a random default value for the primary key?
Thank you,
- April
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-05-19 16:45:59 | Re: Forgotten the master password of db |
| Previous Message | Susan Evans | 2002-05-19 14:04:14 | SSL Error |