Re: special columns - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: special columns
Date
Msg-id 20030402002133.GC17833@svana.org
Whole thread Raw
In response to special columns  ("Michal Adamczak" <pokryfka@druid.if.uj.edu.pl>)
List pgsql-general
On Thu, Mar 27, 2003 at 10:49:42PM +0100, Michal Adamczak wrote:
> can oid, ctid, ...
> be a replacement for an int (like serial) primary key?

Well, OIDs are not guarenteed to be unique (or even present) and CTIDs
change everytime you update the row or vacuum or whenever.

The answer is probably no. SERIALs are much better.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Postgres logs
Next
From: "Roman Fail"
Date:
Subject: Temporary Tables