Re: RE: how do i...

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!

In response to

Responses

Browse pgsql-sql by date

  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...