Re: [HACKERS] Well, then you keep your darn columns

From: Don Baccus <dhogaza(at)pacifier(dot)com>
To: Hannu Krosing <hannu(at)tm(dot)ee>, The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Adriaan Joubert <a(dot)joubert(at)albourne(dot)com>, Peter Eisentraut <peter_e(at)gmx(dot)net>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Well, then you keep your darn columns
Date: 2000-01-24 22:30:19
Message-ID: 3.0.1.32.20000124143019.0107a3c0@mail.pacifier.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

At 11:52 PM 1/24/00 +0200, Hannu Krosing wrote:

>But the decision was (from Vadim IIRC) to drop them, at least in non system
>tables.
>The cited reasons were:
>* crappy implementation that taxed performance (probably fixed by now)
>* nobody else seemed to have them and the push then was to the direction of
> mainstream bean-counting DB with main objective of getting that base
> functionality right.

Regarding this last, Oracle has an equivalent - rowid. In the web
toolkit I'm helping port, it's used somewhat often, and having oid
available has been a convenience.

Having said that, its use in this toolkit's could be replaced by
simply creating a sequence and numbering rows by hand. Their loss
wouldn't bother me particularly even though it would add a little
work (not much) to this project.

>* they take up "too much" space (probably a non-issue in current world of
> dropping disk/memory prices)
>* you can always re-implement them at the application level (the same was
>cited
> for dropping time travel)

Yep!

- Don Baccus, Portland OR <dhogaza(at)pacifier(dot)com>
Nature photos, on-line guides, Pacific Northwest
Rare Bird Alert Service and other goodies at
http://donb.photo.net.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2000-01-24 22:34:33 Re: [HACKERS] Well, then you keep your darn columns
Previous Message Hannu Krosing 2000-01-24 22:18:07 Re: [HACKERS] Well, then you keep your darn columns