From: | Curt Sampson <cjs(at)cynic(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Call for objections: put back OIDs in CREATE TABLE |
Date: | 2003-01-26 22:48:22 |
Message-ID: | Pine.NEB.4.51.0301270745020.596@angelic.cynic.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Sun, 26 Jan 2003, Bruce Momjian wrote:
> Ross, you make some powerful arguments here. Probably the most
> significant was the idea that you need a unique identifier for every
> row, and it should be of a consistent type, which primary key is not.
I don't see why you need a unqiue identifier per row, nor do I see why,
if you are going to have one, it needs to be the same type across all
tables.
Having this may be very desirable, and even necessary, for many or
all object-to-relational mapping frameworks, but that is certainly not
the only thing that postgres is used for. And I still maintain that
if something does need something like of OIDs, it should be declared
explicitly in the database schema (as you have to do in other DBMSes)
and not use a "hidden" feature.
cjs
--
Curt Sampson <cjs(at)cynic(dot)net> +81 90 7737 2974 http://www.netbsd.org
Don't you know, in this new Dark Age, we're all light. --XTC
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-01-26 23:51:18 | Re: New hashed IN code ignores distinctiveness of subquery |
Previous Message | Bradley Baetz | 2003-01-26 22:37:39 | Re: New hashed IN code ignores distinctiveness of subquery |