From: | "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | RE: RE: how do i... |
Date: | 2001-08-12 17:17:08 |
Message-ID: | HOEFIONAHHKFEFENBMNOGENFCAAA.rsanford@nolimitsystems.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
many thanks! ya'll have been a GREAT help!
rjsjr
> -----Original Message-----
> From: pgsql-sql-owner(at)postgresql(dot)org
> [mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Roberto Mello
> Sent: Sunday, August 12, 2001 10:21 AM
> To: Robert J. Sanford, Jr.
> Cc: pgsql-sql(at)postgresql(dot)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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Cedar Cox | 2001-08-12 19:01:13 | Re: REFERENCES constraint |
Previous Message | Roberto Mello | 2001-08-12 15:20:51 | Re: RE: how do i... |