Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 39BCE2E0179 for ; Tue, 18 Mar 2008 13:51:54 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 35933-02 for ; Tue, 18 Mar 2008 13:51:44 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.174]) by postgresql.org (Postfix) with ESMTP id ED03A2E016F for ; Tue, 18 Mar 2008 13:51:45 -0300 (ADT) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu3) with ESMTP (Nemesis) id 0MKxQS-1Jbf2J2tZ1-0003Fp; Tue, 18 Mar 2008 17:51:44 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1Jbf2J-0001iP-00 for pgsql-sql@postgresql.org; Tue, 18 Mar 2008 17:51:39 +0100 Date: Tue, 18 Mar 2008 17:51:39 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Create on insert a unique random number Message-ID: <20080318165138.GA6578@a-kretschmer.de> References: <268179.51357.qm@web54301.mail.re2.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <268179.51357.qm@web54301.mail.re2.yahoo.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX19opbrIHhlzU/XWDr0sfICdpCymPUA6DO5TGGK f2bXgSsiAaXCLsi/kW7v1eL2u/6N7jtRb1bJbTL7g1ZRxUbmtY O/HMaV61v+GRZx+7SmJtn1hpxDzK2Dc X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200803/102 X-Sequence-Number: 30430 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