Received: from mail.taxrefund.com (willy.pdq.net [216.88.69.2]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f7CHI4P85345 for ; Sun, 12 Aug 2001 13:18:04 -0400 (EDT) (envelope-from rsanford@nolimitsystems.com) Received: from mightywombat [66.25.23.179] by mail.taxrefund.com (SMTPD32-7.00) id AA4D90C00CE; Sun, 12 Aug 2001 12:18:05 -0500 From: "Robert J. Sanford, Jr." To: Subject: RE: RE: how do i... Date: Sun, 12 Aug 2001 12:17:08 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 In-Reply-To: <20010812092051.A9044@cc.usu.edu> Importance: Normal X-Archive-Number: 200108/153 X-Sequence-Number: 4374 many thanks! ya'll have been a GREAT help! rjsjr > -----Original Message----- > From: pgsql-sql-owner@postgresql.org > [mailto:pgsql-sql-owner@postgresql.org]On Behalf Of Roberto Mello > Sent: Sunday, August 12, 2001 10:21 AM > To: Robert J. Sanford, Jr. > Cc: pgsql-sql@postgresql.org > Subject: Re: RE: [SQL] how do i... > > > 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! > > ---------------------------(end of > broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/users-lounge/docs/faq.html >