From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
---|---|
To: | "Robert J(dot) Sanford, Jr(dot)" <rsanford(at)nolimitsystems(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: RE: how do i... |
Date: | 2001-08-12 15:20:51 |
Message-ID: | 20010812092051.A9044@cc.usu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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!
From | Date | Subject | |
---|---|---|---|
Next Message | Robert J. Sanford, Jr. | 2001-08-12 17:17:08 | RE: RE: how do i... |
Previous Message | omid omoomi | 2001-08-12 07:05:20 | RE: how do i... |