| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Michal Adamczak <pokryfka(at)druid(dot)if(dot)uj(dot)edu(dot)pl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: special columns |
| Date: | 2003-04-02 00:21:33 |
| Message-ID: | 20030402002133.GC17833@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)svana(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Roman Fail | 2003-04-02 00:48:55 | Temporary Tables |
| Previous Message | Ed L. | 2003-04-02 00:19:55 | Techniques for Recognizing DML Effects? |