From: Roberto Mello <rmello@cc.usu.edu>
To: Robert J. Sanford, Jr. <rsanford@nolimitsystems.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: RE: how do i...
Date: Sun, 12 Aug 2001 09:20:51 -0600
Message-ID: <20010812092051.A9044@cc.usu.edu> (raw)
In-Reply-To: <HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com>
References: <HOEFIONAHHKFEFENBMNOKENBCAAA.rsanford@nolimitsystems.com>
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!
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: rmello@cc.usu.edu, rsanford@nolimitsystems.com
Subject: Re: RE: how do i...
In-Reply-To: <20010812092051.A9044@cc.usu.edu>
* 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