Postgres Pro
Downloads
Home   >   mailing lists

Re: Create on insert a unique random number - Mailing list pgsql-sql

From A. Kretschmer
Subject Re: Create on insert a unique random number
Date
Msg-id 20080318165138.GA6578@a-kretschmer.de
Whole thread Raw
In response to Re: Create on insert a unique random number  (chester c young <chestercyoung@yahoo.com>)
Responses Re: Create on insert a unique random number  ("Campbell, Lance" <lance@uiuc.edu>)
Re: Create on insert a unique random number  ("D'Arcy J.M. Cain" <darcy@druid.net>)
List pgsql-sql
Tree view 
am  Tue, dem 18.03.2008, um  9:43:01 -0700 mailte chester c young folgendes:
> 
> > When inserting a record is there a way to have postgres create a
> > random number for a field such that it is unique?
> 
> 
> you could use oid

No! No oid, it's deprecated. The solution: use serial.


Andreas
-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

pgsql-sql by date:

Previous
From: chester c young
Date:
Subject: Re: Create on insert a unique random number
Next
From: "Campbell, Lance"
Date:
Subject: Re: Create on insert a unique random number