pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
To: pgsql-sql@postgresql.org
Subject: RE: RE: how do i...
Date: Sun, 12 Aug 2001 12:17:08 -0500
Message-ID: <HOEFIONAHHKFEFENBMNOGENFCAAA.rsanford@nolimitsystems.com> (raw)
In-Reply-To: <20010812092051.A9044@cc.usu.edu>

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
> 



view thread (9+ messages)

Message-ID: <HOEFIONAHHKFEFENBMNOGENFCAAA.rsanford@nolimitsystems.com>
Permalink:  ../HOEFIONAHHKFEFENBMNOGENFCAAA.rsanford@nolimitsystems.com/
Also on:    postgresql.org/message-id/HOEFIONAHHKFEFENBMNOGENFCAAA.rsanford@nolimitsystems.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: rsanford@nolimitsystems.com
  Subject: RE: RE: how do i...
  In-Reply-To: <HOEFIONAHHKFEFENBMNOGENFCAAA.rsanford@nolimitsystems.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox