Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7CFL1P05176 for ; Sun, 12 Aug 2001 11:21:01 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: from rmello by fslc.ser.usu.edu with local (Exim 3.22 #1 (Debian)) id 15Vx2p-0002MO-00; Sun, 12 Aug 2001 09:20:51 -0600 Date: Sun, 12 Aug 2001 09:20:51 -0600 From: Roberto Mello To: "Robert J. Sanford, Jr." Cc: pgsql-sql@postgresql.org Subject: Re: RE: how do i... Message-ID: <20010812092051.A9044@cc.usu.edu> References: Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.18i X-Archive-Number: 200108/152 X-Sequence-Number: 4373 On Sun, Aug 12, 2001 at 12:11:10AM -0500, Robert J. Sanford, Jr. wrote: > > i have now discovered that every row in every table is > automatically given a globally unique OID. that's pretty > cool. that means that i don't have to personally create > an OID column for every table. excellent. > > i also enjoy that i can use the OID as an index on tables. > nice, very nice. thank you for making my life easier. It's not a good idea to use OIDs as your primary keys as pointed out by someone else. Look in the documentation for the SERIAL datatype. It will create sequences for you and do the equivalent of what you see in the AUTOINCREMENT types in Access. -Roberto -- +------------| Roberto Mello - http://www.brasileiro.net |------------+ Computer Science, Utah State University - http://www.usu.edu USU Free Software & GNU/Linux Club - http://fslc.usu.edu Space Dynamics Lab, Developer http://www.sdl.usu.edu NEW!!! A Pentium to XT convertion Kit... name?? ---> WINDOWS!